Forum Discussion
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 |
| Americas | 10,000,000 | 5,000,000 | 5,000,000 |
| ASIA | 12,000,000 | 6,000,000 | 6,000,000 |
| EMEA | 14,000,000 | 7,000,000 | 7,000,000 |
Desired outcome:
I want to use the Clustered Column Chart to show Sales Complete & Sales Pending next to each other with the axis showing by Geo.
The Problem:
Currently I am connected to a data cube using a live connection so I cannot create a DAX table to create a category filter.
Question:
How can I create a legend using a DAX measure that will give me the desired outcome given I am using a live connection?
Thank you!
5 Replies
Anonymous Yeah, the usual way of doing this is the disconnected table trick:
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
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
