Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Community Team,
I am having struggles with rounding the numbers. I don't want it to round after 2 decimals, but I am unsure of the dax grammar to make it so. Please find the snapshot. Unfortunately, explaining to the management team rounding issues, it still confuses them.
I would just like the Share Change= 0.9 - 1.0 = -0.1 (not the -0.2 shown from rounding).
My share formulas are:
Share Change = [Current Share] - [LY Share]
Solved! Go to Solution.
Hi @9kRPM
If you would like the value of Share Change displayed in the visual to be equal to the difference between the displayed (i.e. rounded) values of Current Share and LY Share, I would suggest:
Share Change display =
ROUND ( [Current Share], 1 ) - ROUND ( [LY Share], 1 )
I would suggest just using this measure for display in visuals, but use the original Share Change in any calculations.
Does this work for you?
Regards
That worked perfectly Owen! You're awesome! Thank you. I didn't know you could use the round function in a simple calc like that.
Hi @9kRPM
If you would like the value of Share Change displayed in the visual to be equal to the difference between the displayed (i.e. rounded) values of Current Share and LY Share, I would suggest:
Share Change display =
ROUND ( [Current Share], 1 ) - ROUND ( [LY Share], 1 )
I would suggest just using this measure for display in visuals, but use the original Share Change in any calculations.
Does this work for you?
Regards
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |