bar chart with three independent of one another slicers in a single chart

[Anonymous]

Hi,

We're working with a manufacturig db that has information by plant, line, product, date, day of week, hour, and shift. We're setting up a dashboard that gives the user the ability to select productivity by plant, line, product, and date range and see it in a unstacked bar chart. We'd like to set up a single unstacked bar chart that has 35 bars - each hour of the day, 24 bars, each shift, 4 bars, and each day of the week, 7 bars. These three independent of one another, non-user slected slicers are applied to the plant, line, product, and date range slicer combination selected by the user to create the 35 bars. Is this possible?

Thank you

[V-lianl-msft]

Hi @Anonymous ,

Impossible, but you can try to drill through by setting the x-axis as a hierarchy.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , you need put these into a table using union and summarize and then plot .

example

Balance Sheet = union(SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales))
,SUMMARIZE(Sales1,Sales1[Brand],"Col1",sum(Sales1[Sales]),"Col2",sum(Sales1[COGS]),"sort",COUNTROWS(Sales1)) )

but this will not be dynamic