Which chart to use to plot un-summarized value and % value?

[Anirban_25]

Total Business column is the number of business in a year which is an  un-summarized value. Which chart to use to plot this values?

[Fowmy]

@Anirban_25 


Not very clear about the unsummarized term here but it seems you need to visualize both value and % on a single chart then use the combo chart:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

________________________

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 🙂

YouTube  LinkedIn

[Anirban_25]

I want the chart to pull the value from the column and not to SUM/COUNT/AVG it. It table view, there is an option to see un-summarized data but when I try to plot the same in a combo graph, it counts the Total business column. I want the value the way it is.

Problem with Combo Chart

[Fowmy]

@Anirban_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 🙂

YouTube  LinkedIn

[Anirban_25]

I was able to in a Table view but not in charts. I want the chart to pull this value the way it is.

[V-lianl-msft · Accepted solution]

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.

[Fowmy]

@Anirban_25 

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 🙂

YouTube  LinkedIn