Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I have a table that looks like somewhat like this:
Date and Time | How do you value or mkt? | How do you value our support? |
20/10/20 7:00:00 | 8 | 7 |
15/10/20 8:00:00 | 8 | 7 |
03/09/20 10:00:00 | 5 | 4 |
I made a card visual, with the mean of the MKT values, but when I select a month on the slicer filter, it doesn't change the mean value.
To be clear: I want to have a visual showing that the mean of october - the month we're at, so when we're at november, it'll show november and so on - of mkt (8), and another showing the mean of support (7) and so on. And another visual showing that comparing to september ( mean 5), mkt increased in 60% and support increased in 75%, for example.
I also want to know if I need to make a measure for each of those columns or if it's possible to make the mean by the column I have selected.
Solved! Go to Solution.
Hi @Anonymous ,
Like this?
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |