Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
54 | |
37 | |
31 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |