Forum Discussion
Helper IChanges in loading data in bar chart based on slicer selection
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 ,
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
3 Replies
- Anand24
Super User
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 chart3. 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 
bhavadharani- Anand24
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