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 Tuesday, June 23, 2015 1:57 PM updated graphics
June 23rd, 2015 1:52pm

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

Other recent topics Other recent topics