Forum Discussion
Dynamic slicing line chart based on slicers selection
Hello Power BI Community, I'm working on a dashboard where I have a line chart displaying the evolution of conversion rates over time. I'm looking to dynamically segment this line chart based on ...
DIACHROMA I'm having a little hard time understanding the requirement. Although you have well explained it, it is me not able to wrap my head around it. Could you share some sample (dummy) data with the expected result?
Hi parry2k, thank you for your response.
You can download a sample file at this link: https://we.tl/t-dVdkFgLArS. In this example, I'm working with three slicers: Brand, Class, and Channel.
The goal is to have different views in the line chart based on the user's selections in these slicers. I've created a separate page for each possible view.
Here are the rules:
- In the line chart, the default view is to show one line per brand.
- If a selection is made only in the Class slicer, the chart should show one line for each Brand/Class combination.
- If a selection is made only in the Channel slicer, the chart should display one line for each Brand/Channel combination.
- If selections are made in both the Class and Channel slicers, the chart should show one line for each combination of Brand/Class/Channel.