Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to change the format in dax using FORMAT fuction but is not working :
Could you help me to identify the cause ?
Solved! Go to Solution.
@cristianml , You should format all three so that you get a text from all three.
You can also explore calculation groups
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Hi @cristianml ,
Check first if the measure - [_Actual + Backlog CI%] is giving you any result. Looks like youare trying to add a number to a percentage value.
You can also try:
DIVIDE(Numerator,Denominator) and the in the Measure Formatting Tools, formatting it to a percentage value.
Hi @cristianml ,
Check first if the measure - [_Actual + Backlog CI%] is giving you any result. Looks like youare trying to add a number to a percentage value.
You can also try:
DIVIDE(Numerator,Denominator) and the in the Measure Formatting Tools, formatting it to a percentage value.
Hi @PC2790 ,
The measures works fine. No problema with that. se below:
The problem is that I need to change the format but with FORMAT Funcion is not working:
Without FORMAT:
With FORMAT:
Same with Tabular Editor:
Hey @cristianml ,
For future, can you elaborate what turned out to be the issue?
Is it because the percentage value is going out of range of the graph?
@cristianml , You should format all three so that you get a text from all three.
You can also explore calculation groups
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Hi @amitchandak ,
I tryed but still not working. I need to change it to percent format, only the 3rd Var
with FORMAT :
Also I use same measure in visual but not sure why are showing different format. Even if the Format is in %
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |