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.
I created a YTD measure that is calculating YTD numbers throughout the entire year as it should. However, since I have added this measure to my visual, my slicer will no longer filter down to just display the quarter that I select. . Is there anyway to stop this from happening. See below. I have only quarter 1 and 2 selected but the visual still displays the YTD measure for Q3 and Q4. I used a YTD quick measure which is :
YTD =
IF(
ISFILTERED('1. Date'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
TOTALYTD(
AVERAGE('Filled Positions'[Time To Fill]),
'1. Date'[Date].[Date]
)
)
Hi @ahoium
I'm stuck when reproducing your problem.
Is the result of YTD measure correct as you expected?
Which column do you add to the quarter slicer?
How do you create the relationship between the table where this column (added to the quarter slicer) lies and the table 'Filled Positions'?
Without detailed information, i can't give a proper solution for your problem.
Anyway, you could try this workaround.
Create a measure as below
measure1=IF(ISBLANK([average of time fill]),BLANK())
add this measure in the Visual Level filter of this matrix, set "show items when value" is not blank.
Best Regards
Maggie
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |