The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
79 | |
74 | |
50 | |
40 |
User | Count |
---|---|
135 | |
120 | |
75 | |
65 | |
64 |