Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Struggling to get the KPI visual to display current month. Any help would be appreciated!
I have a measure for the previous monthly usage.
Prior Monthly Usage = CALCULATE([Usage Days], PREVIOUSMONTH('Usage'[Started].[Date]))
Then I have another measure to calculate the difference between the current month and previous.
Measure = DIVIDE([Usage Days], [Prior Monthly Usage], BLANK())-1
I want to display the Measure (difference) in the KPI visual but it doesn't want to display the current month. It displays December from the previous year.
Solved! Go to Solution.
Hi @inahury1
Maybe you didn't filter the report / visual.
In this case, the engine default is the end of the current year .
I created an example to show how it works.
With slicer :
Without slicer/filter:
With filter by the "main" measure not blank :
The pbix is attached (the last 3 sheets are examples of what I showed)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @inahury1
Maybe you didn't filter the report / visual.
In this case, the engine default is the end of the current year .
I created an example to show how it works.
With slicer :
Without slicer/filter:
With filter by the "main" measure not blank :
The pbix is attached (the last 3 sheets are examples of what I showed)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
User | Count |
---|---|
88 | |
88 | |
73 | |
66 | |
57 |
User | Count |
---|---|
136 | |
109 | |
91 | |
83 | |
69 |