Forum Discussion

tcirkovsky's avatar
tcirkovsky
New Member
10 years ago

Measures in chart label

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!!^^

Show and Tell

2 Replies

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    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's avatar
      tcirkovsky
      New Member
      10 years ago

      Yea I am aware of that:(

       

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