Forum Discussion

MartaCB's avatar
MartaCB
Frequent Visitor
3 years ago

Show average and selected user data in a line chart

Hi,   I have a set of data for a number of users (user1, user2, etc). I want to be able to show the data in a line chart showing at the same time: - Average - Any selected user data.   This is ...
Need Help
MartaCB's avatar
MartaCB
Frequent Visitor
3 years ago

Hi MFelix ,

 

Apologies for the delayed reply. I had to pause the Power BI development. I am now back at it.

 

I downloaded your file and I really don't understand what is the difference as the functions are the same.

 

Your file shows the average as a static value, if does not matter what filter or slicer I apply, the average is always the same.

 

For my report, that is not the case, I can add the average measure but in the moment I click on the slicer, I get the average for flat 1 or whichever I click on.

 

If I only click on the "average" row of the new table, it goes blank.

I don't really know what to try since it works for you but not for me.

 

Thank you