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.
Hi!
In my report I have a bar chart which shows values which are dependent on which category you choose in a filter. However the values are always shown in one format, based on the data type.
Is there a way to format some values (dependent on which category you choose) as a percentage and others as a whole number for instance?
Or is the only way to split up the data in your datamodel in two fields? (one formatted as percentage, the other as whole number). However this would mean I cannot use one datafield for the chart and one filter..
Hope somebody has an idea!
Many thanks in advance!
Max
Hi @Anonymous
Please can you provide a data sample and the expected outcom.
The below will help you get your question answered quickly, please read it.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hello,
He probably meant something like this:
DESCRIPTION TYPE VALUE
Average # services per case (excluding info cases) # 0.482515549
Average # services per case (excluding info cases) # 0.403145397
Average # services per case (excluding info cases) # 3.088306458
ROS rate % 0.732774807
ROS rate % 0.726065676
ROS rate % 0.739737388
ROS rate % 0.724623188
So, the question would be, how to conditionally change the data type for the values of "value" depending on the character of the column "type".
Thank you
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 |