Forum Discussion
Using a Parameter to switch multiple attributes across multiple visuals
I am a attempting to create a user experience on the same report page for two different audiences (an owning group and a recycle group) on this page there viz for the # Applications and another for Recycle Minutes on both viz I would like to switch between the Team and Area for the seelected group.
Field parametes can't handle the compexity and a calculated measure doesn't validate for dimensional attributtes so I am trying with a calculated column (I know these are frowned apon), the Dax validates but the selected value does not populate, it has 1 blank row with the metric.
See attached workbook, I feel like I am either overlooking something simple or just taking the wrong approach, any guidence would be greatly apprciated.
Show View By Team = switch (True(),'View By'[Selected View By] = "Recycling",'Data' [Recycle Team], 'View By'[Selected View By] = "Owning", 'Data' [Owning Team])
Show View By Area = switch (True(),'View By'[Selected View By] = "Recycling",'Data' [Recycle Area], 'View By'[Selected View By] = "Owning", 'Data' [Owning Area])
2 Replies
See attached workbook?
You might have forgotten to post a sample data. You can post a link to an Excel file in the cloud.Sorry, i thought i could attached a workbook, here is the sample data.
Application Owning Area Owning Team Recycle Area Recycle Team Recycle Time A OA1
OT20 RA1 RT10 10 B OA1 OT20 RA1 RT10 20 C OA1 OT25 RA1 RT10 30 D OA2 OT30 RA1 RT10 40 E OA3 OT30 RA1 RT15 50 F OA3 OT30 RA1 RT15 60 G OA3 OT30 RA2 RT20 70 H OA4 OT40 RA2 RT20 80 I OA4 OT50 RA2 RT20 90 J OA4 OT50 RA2 RT20 95
