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.
I would like to display data on the same graph but change the filter to display individual rows of data. Some rows may have values as numbers and some as percents. Is there a way to tell PowerBI to display the Y-axis as a percent or a value, depending perhaps a column that has a "P" for percent or "V" for value? I realize I can create a calculated column that multiplies the percent by 100 for "P" and just returns the value for "V", but then the % symbol is not included in the graph...
Solved! Go to Solution.
Hi @bruleyn,
We can not set the same column in different format, if you want to add the % in the column using the formula below, the type will be text. You can not use text data type in value field.
Percentage = CONCATENATE( Table1[Column2]*100,"%")
So for your requirement, we can not displysame column in different format.
Best Regards,
Angelia
Hi @bruleyn,
We can not set the same column in different format, if you want to add the % in the column using the formula below, the type will be text. You can not use text data type in value field.
Percentage = CONCATENATE( Table1[Column2]*100,"%")
So for your requirement, we can not displysame column in different format.
Best Regards,
Angelia
Covering 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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |