Forum Discussion
Which chart to use to plot un-summarized value and % value?
Hi Anirban_25 ,
The reason for displaying the total is that the "Business " field has no corresponding field in the graph.
Only the month field as the X axis, the data displayed is all the data corresponding to the month. If you want to show the details, you need to add the corresponding fields to the visual.
Try to use the corresponding field as a legend or x-axis.If it is the x-axis, then drill down.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnirban_25
Can you share a screenshot of the source data? Can you elaborate on what you are trying to achieve?
Can you use a TAble Visual instead which allows the Don't Summarize option?
You cannot show data on a chart unless you summarize it.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
I was able to in a Table view but not in charts. I want the chart to pull this value the way it is.
- Fowmy
You can try it this way,
Create an index column in power query and use merge columns option under Add Column ribbon to create a new column with Index + Segment, this way, each line will be unique. Now, use that column in the x-axis.
let me know after your attempt
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
V-lianl-msftCommunity Support
Hi Anirban_25 ,
The reason for displaying the total is that the "Business " field has no corresponding field in the graph.
Only the month field as the X axis, the data displayed is all the data corresponding to the month. If you want to show the details, you need to add the corresponding fields to the visual.
Try to use the corresponding field as a legend or x-axis.If it is the x-axis, then drill down.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.