I attempted to following the video instructions on Secrets to Building Excel Dashboards based on Non-financial Data - YouTube, using one table; however, encounter an issue with a table properly calculating. Files are attach for review and need assistance to determine what I did incorrectly for table. Can this be done with one table?
Hi Tyrone,
Welcome to our forum!
I see no reason to have the relationship between the PreferredNames and PriorityGroup tables inactive. If you make it active the PivotTables calculate correctly.
Mynda
Mynda, hi,
The PivotTables calculates correctly when it is active; however, the slicer do not work the same as in the video ( https://www.youtube.com/watch?v=PvlH03kvG7c). In the video you have Dim Destination and Mission tables inactive and created a measure (=CALCULATE([Count of Crew Name], USERELATIONSHIP(DimDestination[Destination],Missions[Destination])). Can this be done using only one table?
Hi Tyrone,
Ok, I see what the issue is now. I wasn't following earlier, despite your detailed documentation!
You need a measure that activates the relationship for the PivotTable starting in cell K3 of the Analysis sheet. You can actually just use the Select Group Priority measure in this PivotTable too.
Mynda
Mynda,
I'm exuberant that you resolved my issue; it worked!!! I have been baffled over a month trying to figure out why the slicer would not work with the chart...LUV YA!!!!!!!!!!!!
