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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Suhasndn
New Member

Margin % Creation (without using Measure)

***Requirement - show correct Margin in the Matrix visual while still having the 'Show Data Point as a Table' Option***

 

Hi All,

 

Let me explain my problem in detail.

I have a Matrix Visual that needs a margin calculation as one of the values. The data contains users who have paid for goods. 
Each day has multiple users paying for goods. I have created a margin column in the Back end of the data (SQL Server) as well as in powerbi as a column. [Formula = Profit/Revenue (as a percentage column)]

When I display the margin for each day (or each month), the value comes out inflated/higher. Where as, when I use a measure, it comes out right. 

PS - The reason I want to create a column and not a measure is because when I use a measure in the Matrix visual I lose the 'Show Data Point as a table' option, Which is a critical requirement.

If there is an option to still have the option 'Show Data Point as a table' using a measure, I would gladly accept it. 

Please advice. I am stuck with this for a week.

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.