- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Column Chart Percentages not Equal to Matrix Percentages

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-06-2018 10:09 AM - edited 12-06-2018 10:11 AM

I am trying to create a clustered column chart to display the data in my matrix, but when you hover over the columns to get the exact percentage and not the rounded percentage, the percentage is slightly off.

I want to know what percentage of particpants responded Strongly Agree, Agree, Neutral, Disagree, or Strongly Disagree to Q1 within each year.

I first created a measure to count the number of responses for each response option.

Solved! Go to Solution.

Accepted Solutions

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 12:28 AM

It seems that you may just select Percentage format under Modeling tab.

Sam

All Replies

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 12:28 AM

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 05:47 AM

When I change it to percentage for format, it changes the matric count. If I change my graph measure to percentage format, the percentages are way off (see attachment). When I change my measure to show the value as the percent of grand total, the rounding is correct, but when you hover over, the percentages are slightly off (see attachment). Thank you!

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 06:50 AM

I think the issue is that I am including ALL values in my measure for my graph, whereas I am not including Blanks or NA in my matrix. How do I edit my measure to not include Blanks and NA when calculating percentages? My current measure is:

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 07:05 AM

@mstuve wrote:I think the issue is that I am including ALL values in my measure for my graph, whereas I am not including Blanks or NA in my matrix. How do I edit my measure to not include Blanks and NA when calculating percentages? My current measure is:

#ofRespondentsT = DIVIDE(COUNTA(Satisfaction_Survey[Time]), CALCULATE(COUNTA(Satisfaction_Survey[Time]), ALLEXCEPT(Satisfaction_Survey,Satisfaction_Survey[SurveyYear])))

Hi,

Please have a look at this.

The example used at the bottom of that page might solve your problem although you need to change a bit.

Kind regards,

## Re: Column Chart Percentages not Equal to Matrix Percentages

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2018 10:16 AM

When I format the original measure, I am getting close to the correct percentages. I need to filter out any response that is BLANK or NA - Not Applicable, but I am not sure how to edit my measure to do so.