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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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