Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a mess of calculated columns that will show three lines when selected as "line values" on the graph. Here is an example of the calculated columns:
FP Capacity 8 Hours
FP Capacity 10 Hours
FP Capacity 12 Hours
Meat Capacity 8 Hours
Meat Capacity 10 Hours
Meat Capacity 12 Hours
I have a slicer on my dashboard from a different field that contains:
FP
Meat
What I'm wanting is that when the user selects "FP" from the slicer, the combo chart will automatically graph the three Capacity calculated columns from above that say FP in the title.
Thanks in advance for the help 🙂
Solved! Go to Solution.
Hi @mollig3
Not like measures, calculate columns are computed during database processing and then stored in the model, they do not response to user selections on the report.
So it is not possible to create a calculate column to change dynamically with user selections on the report.
Normally, we can create measures instead, then show the measures on the visual with the corresponding columns from your table.
For example,
FP Capacity 10 Hours = IF ( SELECTEDVALUE ( Table5[TYPE] ) = "FP", MAX ( [FP Capacity 10 Hours2] ) )
Meat Capacity 10 Hours = IF(SELECTEDVALUE(Table5[TYPE])="Meat",MAX([Meat Capacity 10 Hours2]))
Best Regards
Maggie
Hi @mollig3
Not like measures, calculate columns are computed during database processing and then stored in the model, they do not response to user selections on the report.
So it is not possible to create a calculate column to change dynamically with user selections on the report.
Normally, we can create measures instead, then show the measures on the visual with the corresponding columns from your table.
For example,
FP Capacity 10 Hours = IF ( SELECTEDVALUE ( Table5[TYPE] ) = "FP", MAX ( [FP Capacity 10 Hours2] ) )
Meat Capacity 10 Hours = IF(SELECTEDVALUE(Table5[TYPE])="Meat",MAX([Meat Capacity 10 Hours2]))
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |