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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

 

Example1.JPG

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors