Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

100 % Stacked bar chart

Dear All,   I want to come up with a 100% stacked bar chart view as in the attached screenshot. Can anybody suggest what is the most efficient way of doing it?     Data structure provided...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Do you have any specific column that you use as ID? If yes I would split your model in two table one with all the Portfolio information that you will not unpivot and delete all the columns A to I and a second table that would be the ID column and the unpivot of the A to I columns then linked both tables by the ID column.

     

    To calculate the status you would use the 2nd table and for the rest of the setup the other table.

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

You could refer to above suggestions, choose all columns in Edit Queries->unpivot columns, then use meausre to get it or use M code to get count. You could refer to my sample for details.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear dax, thanks a lot for your additional input. But what could I do in cases where there are additional columns and I have to use filter?