Forum Discussion
Multiple lines in line graph based on two multiselect slicers
Hello everyone,
I need to make a dynamic line chart with multiple lines based on two or more multi-select slicers. I know I can do it with one multi-select slicer by adding my data in the legend and filter. And I also know I can make measures with the possibilities that filters can create to show and hide the lines based on the multi-select slicers. But I need to know if I can make the multi-line chart based on two or more multi-select slicers without creating too many measures.
I am new to Power BI and any help would be greatly appreciated.
Thank you very much.
Thanks for the reply from lbendlin.
Hi Iaguas ,
Please try the following steps:
1.Create a new column.
Segment&State = 'Table'[Segment]&"&"&'Table'[State]2.Create a line chart and use the column created as legend.
3.Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thanks for the tips. I want to create time series where the sales date is on the x-axis and the sales value is on the y-axis. I want to be able to use the slicer to filter the values and add them to the graph in separate lines. For example, in the same graph, show the sales that occurred in the year 2024 in relation to the type of customer and their location, each of them in a different line. One line for the customer filter and one line for the location (corporate customer sales and sales in São Paulo). I can choose more than one type of customer and more than one location, each also in a separate line (corporate customer sales, personal customer sales, São Paulo customer sales and Rio de Janeiro sales). In other words, with each selection of the multi-selector slicer, a new line is created in the graph and when the line is deselected, it disappears.
- lbendlin
second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
