Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have below table and ratio is calculated by On/Total
Machine | On | Off | Total | Ratio |
one | 56,919,990.00 | 19,918,078.00 | 76,838,068.00 | 74.08% |
two | 101,407,451.00 | 21,289,453.00 | 122,696,904.00 | 82.65% |
three | 1,582,723.00 | 633,407.00 | 2,216,130.00 | 71.42% |
four | 129,632,460.00 | 20,119,081.00 | 149,751,541.00 | 86.57% |
five | 196,965,125.00 | 25,407,489.00 | 222,372,614.00 | 88.57% |
But when I want use 'Ratio' on treemap or piechart or anything else I can't use it as value of the chart.
Formula of ratio is = FORMAT(DIVIDE(SUM('Data'[On]),SUM('Data'[Total])),"0.00%")
Total is a calculated column not a measure.
Should I write ratio formula differently? Or what should I do?
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
When you use format you are transforming you calculations into text values in this case since you are using a division simply format the value in percentage using the measure bar options no need to use the format syntax then you can use it on your charts:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@Anonymous ,
When you use FORMAT function and format to percenatge it converts to String Value.
Because of whcih the value will not appear on visuals Except on Table, Crad and Matrix.
If you want to change it to Percenatge use Column tools or Measure tools to change the data type to percenatge.
Regards,
Manikumar
Appreciate your Kudos, Accept as Solution if this is helpful.
Proud to be a Super User!
Hi @Anonymous ,
When you use format you are transforming you calculations into text values in this case since you are using a division simply format the value in percentage using the measure bar options no need to use the format syntax then you can use it on your charts:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |