Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
following situation. I build mutliple measures like yoy sales $ & % and mom $ & %.
Now i want to display them in the form of cards on my front page.
This also works fine but i am not getting the value for the current month unless i select it.
I want to see yoy growth from this month compared to last years month.
And the last years month in absolute numbers.
My question is.
How do i get the current month values for the yellow marked numbers.
I mean the data is there and correct i just want to dsiplay it.
You need to use current month filter on page or at visual level
Hello @Anonymous ,
I would try the following:
You have a picture below form a sample report
This should solve the filtering without additional DAX.
If you liked my solution please give it a thumbs up 👍.
If I did answer your question please mark my post as a solution ✅.
Thank you !
Cristian
Hello,
thanks for your quick response.
I tried that but i am only getting following picture ... 😕
That is the challenge that i am facing. My values are all there and if i filter via a slicer for this particular period i have the correct value but somehow i cannot filter on a visual level.
BR,
Paul
Hello @Anonymous ,
The Measures looks right.
Just built a sample Model to test the behaviour ... and it works ...
I marked ny Calendar Table as a Date table ... maybe this is different ... or an additional filter ... or something related to the model
Cristian
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |