Forum Discussion
Dinamic legend line chart
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!
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.
2 Replies
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. :smileyhappy:
Regards
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.
