Forum Discussion
Gross Margin % Inaccurate On Visual
I am trying to create a visual, probably a card, that displays Gross Margin %.
My Revenue displays correctly, as do my Costs and Gross Margin, but I cannot get the Gross Margin % to display correctly.
I have two columns for Gross Margin %: GL Gross Percentage and GL Gross Percentage 2. GL Gross Margin Percentage is Correct, as long as the Format is set to Decimal. But if I set it to Percentage, it’s not correct.
It doesn’t matter which one I select for the visual because it’s always incorrect. What am I doing wrong, and how do I get my Gross Margin % to display correctly in my visuals?
You are welcome,
Instead of Calculated columns You can add DAX measures. Leave calculated coloumns only if needed to filter visuals.
Here couple video for that.
https://www.youtube.com/watch?v=lX2ztEh3tuA&t=3s
https://www.youtube.com/watch?v=Nm9x83J-SBk&t=10s
https://www.youtube.com/watch?v=lMuDz6ViU1w&t=1s
5 Replies
Hi Anonymous
First I have to tell you that adding calculated columns to your model is not a good practice.
Second, you are comparing Cards and Calculated columns that both are in 2 different filter context.
Third and for most it is better that you provide a Sample of your semantic model in order for faster help from the community. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2500104#M889099
You are welcome,
Instead of Calculated columns You can add DAX measures. Leave calculated coloumns only if needed to filter visuals.
Here couple video for that.
https://www.youtube.com/watch?v=lX2ztEh3tuA&t=3s
https://www.youtube.com/watch?v=Nm9x83J-SBk&t=10s
https://www.youtube.com/watch?v=lMuDz6ViU1w&t=1s