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 a line chart with 4 columns added like below. My X -axis is operating_dates.
Now the users feel that lines seem to be crowded sometimes. Do we have an option to select two/three lines only at a time.
I tried creating this but I am able to select only one line at a time by using below steps.
Created a new table as slicer table:
Then create a measure as user selection:
I want two or three lines to select with color coding.
Solved! Go to Solution.
@shikhavidyarthi , Use field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Check this out
https://sqlskull.com/2020/10/17/show-hide-measures-in-line-chart-visuals-using-slicer-in-power-bi/
don't require any preview item and it's a clever solution that allow for even more customization
This was my variation for multiselect:
1)create a table called Slicer, with one column
Filtered_values
line1
line2
line3
2) create a measure like this
@shikhavidyarthi , Use field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |