Can't put measure on any other place other than tooltip in bar chart

[selected_]

I have the below measure that gives certian numbers.

Nr = 
VAR MaxDate = MAX('doc'[EndDate])
RETURN
IF(NOT ISBLANK(MaxDate),
CALCULATE(
LASTNONBLANK('doc'[rating], 1),
FILTER('doc', 'doc'[EndDate] = MaxDate)
        )
    )

I am not able to put it in the axis or legend. Not sure why, it only put the measure on tooltip when using barchart visual but works fine on table visual. Any help how I can fix it?

[v-yiruan-msft · Accepted solution]

Hi @selected_ ,

The measure cannot be used directly as an axis or legend in a chart in Power BI. This is because a chart must present the logical relationship between the data, and the data must be grouped according to certain standards (dimensions), and then various aggregation operations are performed. This is the fundamental reason why the measurement value cannot be used as the axis of the chart. 

If you want to put it in Axis or Legend option, you can create a calculated column to replace the original measure. One thing to note is that the value of the calculated column cannot be changed by the slicer or by user interaction.

Calculated Columns and Measures in DAX

Calculated Columns vs Measures

Best Regards

[Greg_Deckler]

@selected_ 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...

[selected_]

?

[selected_]

hi

I don't understand how it apply to my issue with my measure when I don't mention the records in the measure like Attended and NotAttended. 

can you show me how to solve it via my measure? thanks!