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.
Hi everyone,
I want to display only those measures in the line chart , the ones that i have selected in my slicer. Is it possible ?
Bcoz, if i select 1 slicer option then it is showing me correctly, but when I select 2 options (multi select), it is showing me all the options of the slicer in my line chart.
So, I would like to ask is it possible to show only that no. of options in the line chart that is selected in the slicer ? (say, it can be 1, 2,3...5 )
Thanks !
Solved! Go to Solution.
Lets say you currently have 4 RawMeasures: A, B, C, D.
You can follow the steps:
1. Enter Data to create a Slicer Table with a Column includes those Measure Names.
2. Create another 4 new measures to be used in the chart based on the Raw Measures:
Measure A = IF(CONTAINS('Slicer table','Slicer table'[Measures],"A"),[Raw Measure A],BLANK())
Measure B = IF(CONTAINS('Slicer table','Slicer table'[Measures],"B"),[Raw Measure B],BLANK())
Measure C = IF(CONTAINS('Slicer table','Slicer table'[Measures],"C"),[Raw Measure C],BLANK())
Measure D = IF(CONTAINS('Slicer table','Slicer table'[Measures],"D"),[Raw Measure D],BLANK())
3. Create a slicer with column in the slicer table.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am kind of confused with your question. What are the options in your slicer?
Do you mean you want to have a slicer that includes measure names that you can filter to show only selected measures in the chart?Can you explain your problem with some pictures.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For eg: I have made this slicer and A,B,C,D are four measures , So i want to display these 4 measures on a line chart . Currently I am able to display 1 measure at a time on line chart and when i multi select (for eg: 2 measures i.e A and B), then the graph will show me all the measures that are there in the slicer.
So, basically i am unable to see the number of options that i selected from the slicer ?
Thanks !
Lets say you currently have 4 RawMeasures: A, B, C, D.
You can follow the steps:
1. Enter Data to create a Slicer Table with a Column includes those Measure Names.
2. Create another 4 new measures to be used in the chart based on the Raw Measures:
Measure A = IF(CONTAINS('Slicer table','Slicer table'[Measures],"A"),[Raw Measure A],BLANK())
Measure B = IF(CONTAINS('Slicer table','Slicer table'[Measures],"B"),[Raw Measure B],BLANK())
Measure C = IF(CONTAINS('Slicer table','Slicer table'[Measures],"C"),[Raw Measure C],BLANK())
Measure D = IF(CONTAINS('Slicer table','Slicer table'[Measures],"D"),[Raw Measure D],BLANK())
3. Create a slicer with column in the slicer table.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tarun912 ,
You may try to change your measure like the below one:
IF(CONTAINS('Table (4)','Table (4)'[Month name],"June"),6,BLANK())
That means when the user selects "June" in the month name slicer, it shows 6, otherwise, blank().
You can see I didn't select April, so the chart don't have the value of Measure 14.
Aiolos Zhao
Proud to be a Super User!
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |