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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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