March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I need to calculate the percentage (not the GT) for the report with multiple filter conditions. I could able to resolve this when having only one filter. the main requirement is the filter conditions should be considered as 100% and do the calculation but my logic considering the GT and getting the percentage wrong...
I have columns like
State Gender age group salary range marriage status
In this, I need to calculate the percentage in the clustered column chart using state and marriage status as x and y axis
Filers are State Gender age group salary range
sample data shared below
Gender | Age Group | Status | Region | Salary |
Male | 15-24 | UnMarried | City 1 | Lower I |
Female | 15-24 | UnMarried | City 2 | Middle I |
Male | 15-24 | Divorce | City 1 | Lower I |
Male | 15-24 | UnMarried | City 3 | Middle II |
Female | 15-24 | UnMarried | City 2 | Lower I |
Female | 15-24 | Married | City 1 | Lower II |
Male | 15-24 | UnMarried | City 3 | Lower I |
Female | 15-24 | UnMarried | City 1 | Lower I |
Male | 15-24 | UnMarried | City 1 | Lower I |
Female | 25-34 | UnMarried | City 1 | Lower I |
Female | 25-34 | UnMarried | City 1 | Lower II |
Male | 25-34 | UnMarried | City 4 | Middle II |
Male | 25-34 | UnMarried | City 4 | Middle II |
Female | 25-34 | UnMarried | City 1 | Middle II |
Male | 25-34 | UnMarried | City 4 | Lower I |
Female | 25-34 | UnMarried | City 4 | Middle II |
Female | 25-34 | UnMarried | City 1 | Middle I |
Male | 25-34 | UnMarried | City 1 | Lower I |
Male | 25-34 | UnMarried | City 1 | Middle II |
Female | 25-34 | UnMarried | City 3 | Lower I |
Female | 25-34 | UnMarried | City 1 | Lower I |
Female | 25-34 | Married | City 5 | Middle I |
Female | 25-34 | UnMarried | City 1 | Upper II |
Male | 25-34 | UnMarried | City 3 | Lower I |
Male | 25-34 | UnMarried | City 5 | Lower I |
Male | 25-34 | UnMarried | City 1 | Lower II |
Male | 25-34 | UnMarried | City 1 | Middle II |
Male | 25-34 | UnMarried | City 1 | Middle II |
Solved! Go to Solution.
Hi, @rama211976
According to your description, you want to realize it in "clustered column". Right?
Here are the steps you can refer to :
We can create a masure like this:
% = var _cur_count = COUNTROWS('Data table')
var _cur_region=MAX('Data table'[Region])
var _total =COUNTROWS( FILTER(ALLSELECTED('Data table') , 'Data table'[Region]=_cur_region))
return
DIVIDE( _cur_count ,_total)
And then we can put the measure on the visual and we can meet your need:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @rama211976
According to your description, do you mean you want to see the percentage of the status per Satus?
If this , you just need to use the other visual "100% Stacked column chart" and put this on the visual.
If this method does not meet your needs, you can provide us with your desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
My requirement is clustered column chart where I need to display region on x axis and status on Y axis. I will have four filters Gender,Agegroup,region and score...
Status I have Marriage Unmarried and Divorce
If I select all filters then it need to percent of status (total is 100%) for each individual regions.
If I select gender as Female then percent of status (total together should be 100%) for each individual regions.
so the filter will become base as 100% and it needs to show the break of status for each region
I can share the excel copy for more understanding
https://drive.google.com/drive/u/0/folders/1EspAR9KFIjIArh7ZaPG7Pa0jDVGs699F
Hi, @rama211976
According to your description, you want to realize it in "clustered column". Right?
Here are the steps you can refer to :
We can create a masure like this:
% = var _cur_count = COUNTROWS('Data table')
var _cur_region=MAX('Data table'[Region])
var _total =COUNTROWS( FILTER(ALLSELECTED('Data table') , 'Data table'[Region]=_cur_region))
return
DIVIDE( _cur_count ,_total)
And then we can put the measure on the visual and we can meet your need:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, can you elaborate on your requirements?
Dropping the fields you need into a stacked chart should result in the %'s adding up to 100.
what's different that you need?
Regards,
Pi
My requirement is clustered column chart where I need to display region on x axis and status on Y axis. I will have four filters Gender,Agegroup,region and score...
Status I have Marriage Unmarried and Divorce
If I select all filters then it need to percent of status (total is 100%) for each individual regions.
If I select gender as Female then percent of status (total together should be 100%) for each individual regions.
so the filter will become base as 100% and it needs to show the break of status for each region
I can share the excel copy for more understanding
https://drive.google.com/drive/u/0/folders/1EspAR9KFIjIArh7ZaPG7Pa0jDVGs699F
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
19 | |
15 | |
14 | |
10 |
User | Count |
---|---|
62 | |
25 | |
24 | |
22 | |
16 |