Forum Discussion

Guille's avatar
Guille
Frequent Visitor
8 years ago
Solved

Use Measure as chart legend in Direct Query Mode

Hi everybody, have hit a roadblock and would appreciate your help on this. I am aware of limitations in DAX when using Direct Query mode. I have a table with the following columns among many more ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Guille,

     

    It is not possible to add a measure as chart legend, as measure actually returns a single value. We can only add a column into legend section.

     

    In your scenario, I would suggest you create two separately measures for “Meet Criteria” and “Don’t Meet criteria”. Add these two measures into Values section of the chart.

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Guille,

 

It is not possible to add a measure as chart legend, as measure actually returns a single value. We can only add a column into legend section.

 

In your scenario, I would suggest you create two separately measures for “Meet Criteria” and “Don’t Meet criteria”. Add these two measures into Values section of the chart.

 

Regards,

Yuliana Gu

deepavaishnava's avatar
deepavaishnava
Frequent Visitor
4 years ago

Thank you so much. I was stuck in a similiar scenerio from past 2 days. After reading this, got it resolved.