How to show Total Sale value Bar chart or any visual in Power BI

[Anonymous]

Hi Folks,

Can anybody please help me in getting Total Sale in one bar in Bar Chart visual as show below in picture.

I have calculated total in dataset only just to show the example.

[Greg_Deckler]

Probably going to need to use the disconnected table trick. Here is an example:

https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

Basically, create a separate, disconnected table for your x-axis categories. Craft a measure that looks at the MAX value of that column and then returns the correct summation/aggregation.