Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
May I check if it is possible for 1 measure to display 3 lines on my line chart?
My goal is to simplify my measures, as the only difference between "Active Power (kW) - Phase R" & "Active Power (kW) - Phase S" is the column value the measure calculates from (i.e. MAX('Customer1'[Body_W_R] & MAX('Customer1'[Body_W_S]).
Thank you in advance!
Solved! Go to Solution.
I have found a solution to my problem.
Regardless of whether the 3 columns are independent of each other ([Body_W_R], [Body_W_S] & [Body_W_T]).
All you have to do is to create a measure table with R, S, T values. Create a slicer for this RST and using the same RST as the legend. In order to link the measure to the RST slicer use the following example SWITCH logic:
This will enable you to use the RST measure table slicer to swap between measures display. Such that when I select R, [Body_W_R] will display, and if i select R & S, both [Body_W_R] & [Body_W_S] would display.
I have found a solution to my problem.
Regardless of whether the 3 columns are independent of each other ([Body_W_R], [Body_W_S] & [Body_W_T]).
All you have to do is to create a measure table with R, S, T values. Create a slicer for this RST and using the same RST as the legend. In order to link the measure to the RST slicer use the following example SWITCH logic:
This will enable you to use the RST measure table slicer to swap between measures display. Such that when I select R, [Body_W_R] will display, and if i select R & S, both [Body_W_R] & [Body_W_S] would display.
Hi @mit1
If your one Measure is calculated with single column/multiple columns and you want to distribute across different values for example Sales(Measure) across different years that's possible with Legends option.
But if you are creating different measures based on different columns. for example Sales(p1) , Sales(p2), Sales(p3) , then you have to take all three measures in you line chart. beacuse all measures are on different calculation. they are seperate cant be part of 1 measure.
I hope I anwered your question!
You can break lines using legend
but in this case your measure/column should be derived from single measure.
Proud to be a Super User!
Hi @FarhanAhmed ,
Unfortunately, i do not have a common data to be used for legend, so this may not be possible.
These 3 columns are independent of each other, and these are labelled [Body_W_R], [Body_W_S] & [Body_W_T].
Currently I have a slicer with R, S, T as measure table values.
So my dax (simplified) is:
My goal is to use a slicer to swap between measures display. Such that when I select R, [Body_W_R] will display, and if i select R & S, [Body_W_R] & [Body_W_S] would display.
How should this be accomplished?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |