Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
i want to show the all the value separately . any idea thanks in advance.looking for support.
Solved! Go to Solution.
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.
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.
@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
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |