Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
SpiroswayGR
Resolver III
Resolver III

Column Total but 100%

‎03-30-2021 02:02 AM

Dear community,

 

Do you have any solution how can we show column total but should be on % of 100%.

 

I have this solution : 

SpiroswayGR_0-1617094621722.png

 

but i would like to change it like this , so total of subcategory should be 100% (calculation in blue are totally random just to show my expectaion : correct is 16,12% for 2,3% , 4,8% for 0,69% etc)

SpiroswayGR_1-1617094823908.png

 

More information : 

  1. Using Matrix
  2. In rows i have 2 categories : 1st general category 2nd : Revenue bands
  3. value is sum of revenue

 

Thank you in advance

Labels:
Message 1 of 67
3,135 Views
0
66 REPLIES 66
SpiroswayGR
Resolver III
Resolver III

‎04-13-2021 04:10 AM

any update on this specific problem ? thank you

Message 67 of 67
1,862 Views
0
Ashish_Mathur
Super User
Super User

‎04-05-2021 07:32 PM

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 36 of 67
1,902 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:28 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 66 of 67
1,873 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:25 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 65 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:22 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 64 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:19 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 63 of 67
1,877 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:16 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 62 of 67
1,877 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:14 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 61 of 67
1,877 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:11 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 60 of 67
1,877 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:08 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 59 of 67
1,877 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:05 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 58 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 03:03 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 57 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:59 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 56 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:57 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 55 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:54 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 54 of 67
1,879 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:52 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 53 of 67
1,885 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:49 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 52 of 67
1,885 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:47 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 51 of 67
1,885 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:44 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 50 of 67
1,885 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Ashish_Mathur

‎04-06-2021 02:42 AM

@Ashish_Mathur

I can't share the cause of the pbi file of sensitive data.

Message 49 of 67
1,884 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All