Changes in loading data in bar chart based on slicer selection

[bhavadharani]

Hi..Hope all are doing good

I have a slicer as well as Bar chart
In slicer I loaded Bu and in Bar chart I loaded Bu,los,Actual value and budget value.

slicer value 

Bar chart value 

My requirement is 

At first the overall view should be with Bu but after filtering or after selecting the Bu Slicer the chart should display or load los wise data.

please help me...Thanks in advance:-)

[bhavadharani]

Hi @Anand24, But my requirements is to use only one bar chart. 

Can you please help me @Anand24 

[Anand24 · Accepted solution]

@bhavadharani ,
Why don't you use the drill functionality of Power BI visual itself? It will just be an extra click but you will have to use just 1 chart.
Click the below positioned at top right of visual after slicer selection:

This will enable to go from BU to LOS in your case. 
To go back from LOS to BU, click on "Up Arrow" positioned again at top right of visualization.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @bhavadharani ,
As per my knowledge, this is not possible in Power BI. 

3 alternative solutions:
1. Use drill-through functionality
2. Use 2 bar charts: One with BU and 2nd with LOS... Drive LOS chart with clicks on BU chart

3. Use bookmarks to toggle between BU and LOS chart... 2 charts this time as well

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn