Forum Discussion
Show/Hide Columns in Line Chart Visuals with Multiselect Slicer in Power BI #Line Chart, # Slicers,
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.
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-fc4095ae9afd
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
2 Replies
- amitchandakSuper User
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-fc4095ae9afd
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 - BelinFrequent Visitor
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_valuesline1
line2
line3
2) create a measure like this
The_measure_as_line_to_hide_show =IF(CONTAINSSTRING(ALLSELECTED(Slicer[Filtered_values]), "line1"),"My calculated measure","")
3)do the same for line2 and line34)put a slicer in the report with the Filtered_values column5)set the slicer to filter only that chart