Dinamic legend line chart

[mgramajo]

Hi everyone!

I have the following problem: I have a hierarchy with 2 levels, top level is "FACTORIES" and the next level is "MACHINES". Currently I have the data of the amount of minutes that each machine was not working on a given period of time so when I sum that data I get the time each factory wasn't working. I have 4 Factories and each one has a certain number of Machines, when I use FACTORIES on the legend of a line chart I get 4 lines as expected and if I use a slicer and select let's say "Factory 1" I get 1 line on the chart but what I want is to get one line for each Machine inside "Factory 1" and if I also select "Factory 2" I want for all the lines of the machines inside Factory 2 appear and so on. To sum up:

4 FACTORIES so we have a 4 options slicer ----> I select "Factory 1" 

Factory 1 has 10 machines ----> I want 10 lines on my line chart instead of one line that represents "Factory 1" 

Is this possible? Thanks in advance! 

[v-ljerr-msft]

Hi @mgramajo,

I don't think it is possible to do it directly via a Slicer. An alternative solution could be that using Drill Down feature to drill down one Factory at a time on your line chart to get a similar result. For more details about how to drill down in a visualization in Power BI, you can refer to this article. 

Regards

[mgramajo · Accepted solution]

Hello !

Thank you for your answer, I couldn't manage to do what I was asking but I as an alternative solution I use the drillthrough feature.

---