Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Jodes
Helper II
Helper II

Market share for multiple companies by calculated field

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.

3 REPLIES 3
Anonymous
Not applicable

@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 @Anonymous,

 

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?

 

Example1.JPG

Anonymous
Not applicable

@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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors