cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TeyaSax Frequent Visitor
Frequent Visitor

Stacked column chart, how to display total

 Need your help!
How to find and display the total on the stacked column chart? The chart with the line(measure) unfortunately, is not readable for customers.
1. Values in the legend are constantly changing, and the solution that was proposed earlier on the forum (create a measure for each value - can not be used)
2. For total - only unique lines(Query$PatientRef) should be counted!
3.Values in the legend must be present.
3.Screenshot_1.jpg

16 REPLIES 16
chethan Member
Member

Re: Stacked column chart, how to display total

@TeyaSax

 

For total - only unique lines(Query$PatientRef) should be counted!

 

You can use Constant Line from the analytics & you can manually mention the total 

 

Just check this option is this will be workable 

 

 

regards,

Chetan K

TeyaSax Frequent Visitor
Frequent Visitor

Re: Stacked column chart, how to display total

I can calculate manually and use lines of a constant on the chart with a line, but  Line sometimes generates confusion on the audience. i need smth like this ^  total sum of the categories can be shown in each column,

on top.Screenshot_2.jpg

 

regards,

Sasha

Moderator v-yuezhe-msft
Moderator

Re: Stacked column chart, how to display total

@TeyaSax,

Please check if Line and Stacked column chart meets your requirement.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
danextian New Contributor
New Contributor

Re: Stacked column chart, how to display total

What I can think of is using a measure as a tooltip that shows the overall total per venuename. The formula is something like

VENUENAME (ALL) =
//calculates the overall total for venuename only, can still be filtered by other columns
CALCULATE (
    [Count of patientref measure],
    ALL ( 'Table'[venuename] )
)

 

Or you can use the new page tooltip (still in preview) to show a bar chart showing count of patientref broken down by revenue name and another without a breakdown. 

 

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
TeyaSax Frequent Visitor
Frequent Visitor

Re: Stacked column chart, how to display total

Thanks for the advice, but I already wrote that I need a chart without a line!
The amount should be written at the top of the  each column as the block , and the line can not be used (that's the request of the customer)!
sum is the number of unique rows. Is it possible to find the amount (the number of unique lines) and show it on top of the column?

TeyaSax Frequent Visitor
Frequent Visitor

Re: Stacked column chart, how to display total

thanks for the advice. unfortunately this is not what I need(
Ofir Frequent Visitor
Frequent Visitor

Re: Stacked column chart, how to display total

Any new? I"m stuck too...

Super User
Super User

Re: Stacked column chart, how to display total

you can use stack with line chart and make stroke width of line chart to zero and turn "show marker" on. I'm sure that is closer to what you are looking for, or just turn off the market and it will just show the data label, experiement with it and see what works best for you.

 

lineoff.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






likelike Frequent Visitor
Frequent Visitor

Re: Stacked column chart, how to display total

I used to be able to do this within 30 seconds in Tableau. It's dissapointment for Power BI as a modern BI tool.

Hopefully they'll add this basic feature in the near future. 

 

This is accomplished in Tableau using a reference line. 

https://community.tableau.com/thread/212880