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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Khang
Frequent Visitor

Display % in Matrix visual with decimal number formatting - within multiple filtered contexts v2

Hello DAXperts,


I have posted a similar issue before here and that was resolved perfectly.

This one is a different problem as I have different formulas in different contexts.

I have a matrix visual showing data from a "MainData" table.
I have been able to display % numbers for selected rows with a decimal formatted matrix.

This works for the single monthly columns (measures), but does not work for the Full Year (custom measure called "Total"), and also does not work for the corresponding "Budget" full year total (also a custom measure).

 

I want these two columns/measures ("Total" and "Budget") to show % values at selected rows consistent with the other columns in the matrix.


Currently, the decimals also looks to be incorrect. Ideally, the Gross Profit % or any percentages should be divided by Revenue like the other columns.
Ie.
Gross Profit % = Gross Profit / Revenue
Earnings Before Tax % = Earnings Before Tax / Revenue

Please see below image & attached PBIX file.
Any suggestions or workarounds much appreciated.

GP Percentage FY.PNG

 

1 ACCEPTED SOLUTION
Khang
Frequent Visitor

I was able to resolve this, thanks for all the replies.

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Khang 

I think this is very similar to 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dax-CALCULATION-ISSUE/m-p/2484640#M68160

please let me know if you need any further help. 

Khang
Frequent Visitor

Hi @tamerj1,

 

I had a look at the example you posted, unfortunately it is similar but not the same.

If you look at my PBIX file linked above, and refer more so to the first half of the post, it points out that I was able to achieve the % formatting for other columns, but not on the Total & Budget columns specifically. (ie. solution in column 1-12 is different to a solution required in column 13 and different again in column 14.

The two columns (measures) are within several layers of filter contexts and behaves differently to the other columns in the same table.

 

Please have a look and let me know your suggestions/solutions.

Thanks for your help on this.

Khang
Frequent Visitor

I was able to resolve this, thanks for all the replies.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors