Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic legend using a DAX measure

Hi everyone,   Details:   I am using a Clustered Column Chart to show Total sales by geographic area. The data looks like this:   GEO Total Sales      Sales  Complete Sales Pending  Am...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I cannot enter data, I am on a live connection so this option is not given 

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 

Unfortunately, you cannot apply the created measure to the visual legend , and  Live connection does not support the creation of calculated columns and tables.

We suggest you to modify the original model by adding a category table.

 

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-easonf-msft can you elabrate more on adding a category table, what exactly do you mean?

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi, Anonymous 

      The table used to create the category filter should be created in advance when building the LC model, not after the model is connected using powerbi.

       

      Best Regards,
      Community Support Team _ Eason