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,
I have below shown clustered chart created where I want to show % instead of numbers. If I use 'Show value as %' option available in Value field (right click), it calculates the % of the entire data set. But I want to calculate the % between each light blue & dark blue seperately. Example, I want to see in first light blue & dark blue % as 40% & 60% & not 2 &3.
How can I do this. Pls help
Using 'Show value as %' option available in Value field (right click), gives result as below which I don't want. It is considering entire dataset as 100% then deviding all the bars in 100%. I want to consider each light blue & dark blue set of bars seperately as 100%
Solved! Go to Solution.
Hi @harshadrokade ,
Create this measure:
If I answered your question, please mark it as a solution to help other members find it more quickly.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @harshadrokade ,
Can you give some example data from your table? Doesn't need to be with real numbers.
Hi,
Share the link from where i can download your PBI file.
@Ashish_Mathur Sorry Sir, My organisation doesn't allow uplaoding the files anywhere & so I can;t share the PBIx file or link for the same. Will you be able to help me without PBIx file sir, pls
Hi,
Please prepeare a dummy dataset and show the problem clearly on that dataset.
Pls refer below data. I have drawn the clustered column chart also as shown below which is giving wrong %. I want % to be shown on cluster as shown in the table.
Table name - Class
Columns as below-
'Class | 'Status | 'Count | '% to be shown on Clustered column chart |
Class A | Pass | 20 | 53% |
Class A | Fail | 18 | 47% |
Class B | Pass | 27 | 79% |
Class B | Fail | 7 | 21% |
Class C | Pass | 27 | 57% |
Class C | Fail | 20 | 43% |
Class D | Pass | 11 | 31% |
Class D | Fail | 25 | 69% |
Class E | Pass | 13 | 35% |
Class E | Fail | 24 | 65% |
Class F | Pass | 26 | 51% |
Class F | Fail | 25 | 49% |
Power bi visual with count-
Power bi visual with % (% appearing here is wrong. I want the % as shown in table)-
Hi,
You may download my PBI file from here.
Hope this helps.
You are welcome.
Hi @harshadrokade ,
Create this measure:
If I answered your question, please mark it as a solution to help other members find it more quickly.
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 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |