Pivot Diagram Shape is Showing MS Access Datafield ID (numerical value) Instead of the Text in the MS Access Datafield

I have created a Pivot Diagram that references a table (MS Access). The table contains Lookup fields that reference values in other tables.  My Pivot Diagram shape title displays a numeral on the left margin of the Title Field of the data shape.  I'm flummoxed.  I've ran into this in Access when creating reports but that is corrected by changing the the report field format in the datafield properties sheet.  That is not an option in Visio.  How do I correct this?

I have this:

referenced table is: 

Instead of the numeral "2" in the shape title, I need the report to display the actual text of the Access datafield.

Thanks.

-Mike


  • Edited by M K G 17 hours 32 minutes ago updated graphics
June 23rd, 2015 9:54am

Hi Mike,

Based on my test, we might assign the Data graphics to the shapes, and then it'll display the actual text of the Access data field.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
June 24th, 2015 1:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics