Forum Discussion
STACKED COLUMNS WITHOUT NEW TOTAL
Hi i have a problem trying to show 3 simples things.
my final obejctive is to do something like this:
i tried a lot of ways i think the best way is using in de stacked column chart the line for the "INTERRUPTION QUANTITY"
and then in the same column put the "RUNNING HOURS" AND THE "INTERRUPTION DURATION" i make it like this:
THE PROBLEM IS THAT THE STACKED COLUMNS SHOW THE SUM OF THEM LIKE GREEN ON THE RED TOTAL, AND I WANT TO SHOW THE RED OVER THE GREEN AS WHEN YOU MAKE A 100% COLUMN CHART.
I DONT KNOW IF I'MM BEING CLEAR, I HOPE SO.
PLEASE I NEED HELP TO DO THAT OR ANOTHER SUGGESTION TO COPY THE FIRST GRAPHIC IN POWER BI
Hi JUANROVALETTI
Firstly, you can try to achieve your desired graph using error bars.Please refer to the file, I attached in the discussion:
Your case seems even simpler because it is just one cluster.
According to Stacked you can calculate separate measures for every category and put them in the order that you want
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
JUANROVALETTI thanks for reaching out. Use inforiver or zebra bi viz from app source. It will solve your problem.
If my answer helps you, hit 👍 and accept it as a solution.
5 Replies
- Ritaf1983
Super User
Hi JUANROVALETTI
Firstly, you can try to achieve your desired graph using error bars.Please refer to the file, I attached in the discussion:
Your case seems even simpler because it is just one cluster.
According to Stacked you can calculate separate measures for every category and put them in the order that you want
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
yeah thanks but that isn't what i want, the main problem is:
example:
MEASURE 1 (MAY)= 10
MEASURE 2 (MAY) = 50
in my column i would like that the total of the column in may to be 50 but also over that column show another column of the value of 10.look the image i would like do something like post the red value over the green without modifing the haight of the column.
- Ritaf1983
Sorry .... I don't understand what you are trying ti do...
okey haha sorry,
when i use column stacked chart, the height of the column is the sum of the measure 1 and 2, and i want that that the total height be equal to the value of measure 1.
rubayatyasminCommunity Champion
JUANROVALETTI thanks for reaching out. Use inforiver or zebra bi viz from app source. It will solve your problem.
If my answer helps you, hit 👍 and accept it as a solution.
