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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.