cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## how to present data as Percent of grand total(near cathegory description)?

Hello,

could someone help me please with my question?

I have vizualized my data in a diagramm as here in the example, but I need to present the numbers  in percents of grand total (near cathegory descriptions) , i.d. Bikes(2%), Auto(3%), Tracks(88%) etc. Is there some function in Power BI for presenting the percents near description?

Any idea?

Thanks a lot!!

1 ACCEPTED SOLUTION
Community Champion

hi @Jolyon

you can do it this with Quick Calc in the column in Values

Lima - Peru
3 REPLIES 3
Community Champion

hi @Jolyon

you can do it this with Quick Calc in the column in Values

Lima - Peru
Helper III

thanks @Vvelarde!

that was exactly what I looked for)

regards,

Jolyon

Community Support

Hi @Jolyon,

It seems that you are using a pie chart visual to display the data, right?

In your scenario, you can create a measure to return the percentage value for each category, then place this measure in chart Values property. Change Label Style as Both. See:

percentage = DIVIDE(SUM(DimSalesTerritory[SalesTerritoryKey]),CALCULATE(SUM(DimSalesTerritory[SalesTerritoryKey]),ALL(DimSalesTerritory)))

Best Regards,
Qiuyun Yu

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors