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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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