Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Currently I have a dataset which tracks production vs a planned figure, however we have 3 different planned figures - one we use for external customers, one for internal customers and another which is an internal department stretch target.
What i'm trying to develop is a calculated column which shows production vs the selected plan version the user chooses from a slicer on the visualisation. Example dataset below and type of visualisation I'm trying to develop.
I've seen other ways to do this with measures however I'd like to try and do it as a column as this column is then used to feed in to other calculations.
Solved! Go to Solution.
Select the target columns and choose Unpivot Columns in Query Editor, then drag [Attribute] to Slicer.
Select the target columns and choose Unpivot Columns in Query Editor, then drag [Attribute] to Slicer.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |