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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Raj341
Frequent Visitor

How to achieve Percent of column total through DAX in bar chart

Hello everyone,

We've successfully obtained the "Percent of Column Total" results in the Matrix visualization. Now, I'm looking to replicate the same outcome in a bar chart. Despite attempting various DAX queries, I haven't been able to achieve the desired results.
Note: I am using Clustered bar chart


Raj341_1-1713894531411.png

Apps,Spent time_bucket_hr , viewers
a         0-2                              60
b         2-4                             70    
a         2-4                             130
b        0-2                               40

Raj341_0-1713894440165.png

Example:

Raj341_2-1713894788056.png

 


Thanks in advance.
Please help me to fix the issue

1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hi @Raj341 

 

You can try this measure. 

Measure = DIVIDE(SUM('Table'[viewers]),CALCULATE(SUM('Table'[viewers]),ALLSELECTED('Table'[Apps])))

vjingzhanmsft_0-1713936534783.png

Your current measure uses ALL('Sheet1'), this will remove all filters on table 'Sheet1', which finally gives you the percent of grand total. To have the percent of column total, you need to remove filters on the column field. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

5 REPLIES 5
perezco
Advocate III
Advocate III

just mantain the classic visualization ..and you will get it.
the fancy new one is not allowing it .

v-jingzhan-msft
Community Support
Community Support

Hi @Raj341 

 

You can try this measure. 

Measure = DIVIDE(SUM('Table'[viewers]),CALCULATE(SUM('Table'[viewers]),ALLSELECTED('Table'[Apps])))

vjingzhanmsft_0-1713936534783.png

Your current measure uses ALL('Sheet1'), this will remove all filters on table 'Sheet1', which finally gives you the percent of grand total. To have the percent of column total, you need to remove filters on the column field. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Thankyou for sharing the logic.
I am using wrong Dimesion, based on your screenshot. I realized my mistake.
-Thanks a lot for sharing the logic

amitchandak
Super User
Super User

@Raj341 , The measure formula is correct. You can use allselected in place of all, so the other filter can pass.

 

You can enable the label to show it on visually.

 

You can use this new measure as label details to show both labels

 

New Power BI Data Label Customizations (December 2023) - Enhance Your Data Analysis & Reporting:
https://www.youtube.com/watch?v=qe3eW4OkAN8&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L

Thankyou for sharing the useful link to dive into more granularity 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors