Display a value on a bar chart other than the one explicitly put into value field

[Anonymous]

I have a table containing the following information in its columns: a product, a month, a quantity number and a satisfaction percentage. What I would like to do is display this information in a bar chart such as having the month on the x axis, the product in the legend, the quantity in the values. So far so good, this works perfectly fine.

Additionally to that I would like to display the average satisfaction percentage permanently for each month (or, even better, for each month AND product). If I put it in a quickinfo it works fine, but this is obviously not a permanent display.

I already tried using a combo chart with bar and line, however if I filter on a specific product the line with the satisfaction percentage does not update accordingly (while the quick info values do).

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

Table:

DateTable(a calculated table):

DateTable = CALENDARAUTO()

You may create a relationship between two tables.

Then you can create a measure as follows.

Average satisfaction percentage = 
CALCULATE(
    AVERAGE('Table'[Satisfaction percentage]),
    FILTER(
        ALLSELECTED(DateTable),
        DateTable[Date].[Year] = MAX('DateTable'[Date].[Year])&&
        DateTable[Date].[Month] = MAX(DateTable[Date].[Month])
    )
)

Finally you may use 'Line and clustered column chart' visual to display the result. Make sure you click the 'Expand all down one level in the hierarchy'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.