Forum Discussion

shikhavidyarthi's avatar
shikhavidyarthi
Frequent Visitor
3 years ago
Solved

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 o...
Need Help
Belin's avatar
Belin
Frequent Visitor
3 years ago

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

The_measure_as_line_to_hide_show =
IF(
    CONTAINSSTRING(ALLSELECTED(Slicer[Filtered_values]), "line1"),
    "My calculated measure",
    ""
)
3)do the same for line2 and line3
4)put a slicer in the report with the Filtered_values column
5)set the slicer to filter only that chart