Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to remove "demand.00" from values section. I tried INT and ROUND function to solve but nothing worked. If I'm changing it to integer then "3M MDS % change" is also changing to integer, but it should be in %.
Solved! Go to Solution.
Have you tried FORMAT function ?
FORMAT(YourValue, "0.0") & "%"
Yes, I tried.
Great. Please mark my solution as solved.
Yes, I tried.
@Anonymous , Try updating measure as
Total Demand =
VAR LWK = CALCULATE(
SUMX(Append1, TRUNC(Append1[Demand])),
Append1[WK] = "LWK",
Append1[Month-Year] >= MIN('Append1'[Month-Year]),
Append1[Month-Year] <= EDATE(MIN('Append1'[Month-Year]), 2))
VAR CWK = CALCULATE(
SUMX(Append1, TRUNC(Append1[Demand])),
Append1[WK] = "CWK",
Append1[Month-Year] >= MIN('Append1'[Month-Year]),
Append1[Month-Year] <= EDATE(MIN('Append1'[Month-Year]), 2))
VAR Change = SWITCH(
TRUE(),
LWK = CWK, 0,
LWK = 0 && CWK <> 0, 100,
CWK = 0 && LWK <> 0, -100,
LWK <> 0, DIVIDE((LWK-CWK), LWK, 0) * 100 )
RETURN
IF(ISBLANK(MAX(Append1[Month-Year]))=FALSE(),
IF(DISTINCTCOUNT(Append1[Month-Year])>1,
Change,
SUMX(Append1, TRUNC(Append1[Demand]))
)
)
Proud to be a Super User! |
|
Sorry but it is still showing same as above.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |