Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:-)
Solved! Go to 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 !!! |
@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 !!! |
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 !!! |
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |