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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply

Simple Bar chart without calculation

Hey Guys,

 

I have issue in creating the simple bar chart in PowerBI. While it can be easily made on MS Excel. While I make chart in PBI it summarised the values. I have tried converting the data type to text, number. If I convert to text then on bar chart Y axis it takes count of column based upon category. I have changed in data view - Column setting to "Don't summarised" still I am not success. Any lead to achieve the chart would be held.

IMG_20230620_014648.jpg

sample random data

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Siddharth_2987 

 

Download sample PBIX file

 

Choose MAX as the aggregation for the y-axis and it should work.

 

maxy.png

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @Siddharth_2987 

 

Download sample PBIX file

 

Choose MAX as the aggregation for the y-axis and it should work.

 

maxy.png

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.