Measures in chart label

[tcirkovsky]

Hi guys,

recently on FB in World of Power BI group was published question about getting measure values into the Label in charts.

Here is my solution, but its not perfect and maybe someone will find better way or some improvment of my solution. But i hope it will help to someone.

1. Create new measure as "CreatedMeasure" (in dimension table dim_Colors) which calculates required value for every color CreatedMeasure = sum(Facts[Value])
2. Create new column in dimension table dim_Colors[Color_name] & " (" & [CreatedMeasure] & ")"
3. Use this new column as Label in chart.

Issue:

• Filters doesn't work on values in Label:/  (But maybe someone knows DAX well unlike me and can create better query)

PS: Bar chart would be better!!^^

[greggyb]

Anything defined as a calculated column will not be dynamic at report viewing time, and will only change during dataset processing.

I am not familiar enough with the custom visualization API to say whether this is possible in general, but I can tell you this isn't doable with the stock visualizations.

[tcirkovsky]

Yea I am aware of that:(

This solution is applicable at least in static report or its part if customer needs something like that.