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.
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
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,
Please check if Line and Stacked column chart meets your requirement.
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.
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?
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.
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.