Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Clustered columns chart showing incorrect values

Hi All, 

 

Sample PBIX file is here 

I need to display Employee’s age profile similar to this. 


Samples .jpg

 

I am  using SharePoint Online and want to use Power BI for reporting purposes.

So I made a list as follows as Number as data type

 

 

01 List Data Type Number.jpg
users are filling within the SharePoint form as follows:  

03 User Entry Form.jpg

So I made some transformation and changed the Data Type (Decimal Number) within Power BI desktop as follows:


04 User Entry Form.jpg

 

The first column 20To30 years group shows values as follows, 26%, 20%, 26%, 20% and 26%.


But when I drag values from fields for 20 to 30 years, 31 to 40 years,  41 to 50 years etc. the chart shows in different way and first column shows 150% which is also not correct


05 Dashboard Incorrect Values.jpg

 

and for the 20 to 30 years column I am using default SUM and NO Caclucation. 

 

06 Sum and No Compute.jpg

 

Any suggestions will be highly appreciated.

 

 

1 ACCEPTED SOLUTION

Hi,

 

You should change the summarisation function fro SUM to AVERAGE.  Average of 26,20,26 and 20 is 23%


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
MFelix
Super User
Super User

Hi @Anonymous,

 

Looking at your data what is happening is that your column is calculated in your table the total od  20-30 years gives 118% taking out the 26% from BU2 it will give you the 92% you are seeing, based on your data what is the number you want to show the max value - 26% or an average of the values (26% - 20% - 26% - 20%), you should select on your summarization the average or max value.

 

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix  ..

 

Thanks for your reply ..

 

The customers wants EXACT values for the Age chart 

 

Any suggestions? 

 

Hi,

 

You should change the summarisation function fro SUM to AVERAGE.  Average of 26,20,26 and 20 is 23%


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi @Ashish_Mathur and @MFelix ..

 

Thanks for your valubale inputs. The Age Chart works well with Average within Visualization ..

 

Age Chart.jpg

 

Thanks again!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Are you different lines in the image of the table corresponding to each of the BU's you show in the first graph? Again loking at your data on the first image you have several BU on the PBI chart you only have two probably there is an incorrection on the BU column that makes it a sum and not a value per grouping.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.