Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have a dataset with over 100 developers. I would like to have a giant pie chart that allows me to show market share of each developer. But I have multiple categories of market share I need to show. Eg. Starts, Occupied, Unoccupied. Is there a way to use the slicers for my calculated fields so that this one pie chart will change based on which metric I want to show?
If not, is there another way to accomplish this? I would be OK with having multiple pie charts and using a slicer for "Developer." I would like the pie chart to show market share of selected Developer and market share of the rest of the market.
@Jodes,
Could you please share sample data of your table and post expected result following the guide in this blog? In your scenario, do you get the desired result when you create a slicer using developer field and filter the pie chart with this slicer? Or you may want to show different measures based on slicer selection?
Besides, you mention that you will be OK with having multiple pie charts and using slicer for "Developer", bookmark feature should meets your requirement, you can review this video to get details.
Regards,
Lydia
Hi @v-yuezhe-msft,
I believe your second link will work best for me: show different measures based on slicer selection.
Here is a sample of my dataset. Is there anything else I can provide to help?
@Jodes,
Have you tried to create required measures following the guide in that blog?
If you have questions about the DAX, please share sample data of the table which we can copy and paste, and post expected result following the instructions in this blog:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Regards,
Lydia
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.