Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all! Need some help with a visual:
I have a Power BI report that shows connections between companies. Each row of data features a Company column and Company partner column. I have filters for both Company and Partner Company on this page. When I filter to Company, I want the bar chart - which shows the partnering company count - to have a legend of Partner Company. When I filter to Partner Company, I want the bar chart to have a legend of Company. Goal is to show who these companies are partnering with. Due to another visual, I require both Company and Partner Company filters and aniticipate both to be used by the end user.
How can I make this visual work? I've taught about overlaying two bar charts, each with a different legend but do not know how I owuld hide a visual based on whether a filter is one.
Solved! Go to Solution.
Hi @cake28424
The proposed solution is to overlay two bar charts and dynamically display them based on the applied filter, which is a feasible approach.
To achieve this effect, you can utilize bookmarks and the selection pane.
First, create two separate bar charts. One chart will have 'Company' as the legend (to be displayed when 'Partner Company' is filtered), and the other will have 'Partner Company' as the legend (to be displayed when 'Company' is filtered).
Use bookmarks to capture the state of your report page for each filter scenario.
You'll need to create two bookmarks:
Bookmark 1: Hide the 'Company' legend chart and show the 'Partner Company' legend chart.
Bookmark 2: Hide the 'Partner Company' legend chart and show the 'Company' legend chart.
Use the Selection Pane: The Selection Pane allows you to control the visibility of visuals on your report page. Use it in conjunction with bookmarks to show/hide the appropriate chart based on the filter applied.
Create buttons. When clicked, the corresponding bookmark will be activated.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
Hi @cake28424
The proposed solution is to overlay two bar charts and dynamically display them based on the applied filter, which is a feasible approach.
To achieve this effect, you can utilize bookmarks and the selection pane.
First, create two separate bar charts. One chart will have 'Company' as the legend (to be displayed when 'Partner Company' is filtered), and the other will have 'Partner Company' as the legend (to be displayed when 'Company' is filtered).
Use bookmarks to capture the state of your report page for each filter scenario.
You'll need to create two bookmarks:
Bookmark 1: Hide the 'Company' legend chart and show the 'Partner Company' legend chart.
Bookmark 2: Hide the 'Partner Company' legend chart and show the 'Company' legend chart.
Use the Selection Pane: The Selection Pane allows you to control the visibility of visuals on your report page. Use it in conjunction with bookmarks to show/hide the appropriate chart based on the filter applied.
Create buttons. When clicked, the corresponding bookmark will be activated.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |