Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Bar Chart with multiple Columns as Axis and Count for value

First post here and I've tried searching a few things and I am sure this has been asked but I wasn't sure what the right terms were.  Thank you for all your help so far!   I have a sample table bel...
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    Do you want to get the output below?

     

     

    If it is, you could folloe the steps below.

     

    1. We need do some change for your data model in Query Editor. Upivot columns Test1 and Test2, then you will get the table like below.

     

    2. Apply and Close. Create the measure with the formula below.

    mea = CALCULATE(COUNTROWS('Table1'),FILTER('Table1','Table1'[Value]=1))

    3. Create the Bar chart with Attribute as Axis and measure as value.

     

    More details, you could refer to the attachment.

     

    If you still need help, please share your desired output so that we could help further on it.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

Do you want to get the output below?

 

 

If it is, you could folloe the steps below.

 

1. We need do some change for your data model in Query Editor. Upivot columns Test1 and Test2, then you will get the table like below.

 

2. Apply and Close. Create the measure with the formula below.

mea = CALCULATE(COUNTROWS('Table1'),FILTER('Table1','Table1'[Value]=1))

3. Create the Bar chart with Attribute as Axis and measure as value.

 

More details, you could refer to the attachment.

 

If you still need help, please share your desired output so that we could help further on it.

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can you please explain how you made the changes to the data in the query?