Forum Discussion

chodgson's avatar
chodgson
Frequent Visitor
7 years ago
Solved

Stacked column chart from one query?

Hi

 

I'm very new to Power Bi and haven't even looked at DAX yet, so I'm hoping someone can provide advice.

 

Below is a screenshot of my data file and an example of the stacked column chart I am trying to produce for each criterion:

 

 

 I have only been able to achieve the visuals previously by creating a separate query for each criterion and each level of "expectation".  As there are 6 x criterion and 3 x levels, that meant I created 18 separate queries.

 

I feel sure there has to be a much more efficient way of doing this and would really appreciate any suggestions.

 

Thanks

 

 

 

  • chodgson's avatar
    chodgson
    7 years ago

    Hi Jimmy

     

    Thanks for responding to my post.  I currently have a colleague looking at it who thinks the conditional sort could be done in Excel before pulling the data into Power BI.  I'll update on here when I know the outcome.

     

    Thanks

    Catherine

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi chodgson,

     

    Could you share the curreng query you are using in a stacked column visual?

     

    Regards,

    Jimmy Tao

    • chodgson's avatar
      chodgson
      Frequent Visitor
      7 years ago

      Hi Jimmy

       

      Thanks for responding to my post.  I currently have a colleague looking at it who thinks the conditional sort could be done in Excel before pulling the data into Power BI.  I'll update on here when I know the outcome.

       

      Thanks

      Catherine