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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
THENNA_41
Post Partisan
Post Partisan

How to show the all the value instead total sum

i have the table name called  Top summary data. in this table looks like the below 

 

Month        Value      Measure                      Metric Name

Jan               28%         Reports                    Accuracy & Timeliness

Jan              8.30%         OOS                    Value weighted critical Inventory

Jan              100%      Excess Inventory     Value weighted critical Inventory

 

 

when i add the value line and column chart and select mulitple selection   its total value sum up like  the below screen shot 

 

THENNA_41_0-1649672815054.png

 

i want to show the all the value  separately .  any idea thanks in advance.looking for support.  

 

 

 

1 ACCEPTED SOLUTION
PC2790
Community Champion
Community Champion

You are getting all the value summed in one because you have taken Month in the x axis and all the values in your data are of January month.

Try adding other parameters in the x axis based on which you will get the required distinction.

View solution in original post

3 REPLIES 3
PC2790
Community Champion
Community Champion

You are getting all the value summed in one because you have taken Month in the x axis and all the values in your data are of January month.

Try adding other parameters in the x axis based on which you will get the required distinction.

amitchandak
Super User
Super User

@THENNA_41 , You can use a slicer and increase values on the column axis and legend.

If you want to increase the measure for the line I doubt that

 

You can check calculation groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak  thanks for the reply sir . i want the all the three values in in column graph instead total sum sir 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors