I have consumption data shown using date hierarchy (Year, Month... Day and Half hourly).
And I would like to be able to show data for Quality Code ONLY when users are at Day level of the hierarchy.
I've created a measure using ISINSCOPE function, tested with tooltip, looks good, BUT I can't add the new measure to Legend!
Any suggestions? Many thanks.
Hi @abotlindsey ,
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 the legend section.
you could try to create two separate measures like“NO Quality Code” and“Quality Code”，add these two measures into Values section of the chart.
Community Support Team _ JoeyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.