Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want my YTD line graph to show Jan-Oct when Oct is selected on the slicer but it is only showing data for October?
Solved! Go to Solution.
Hi @LukeDurrant
I ran the testing as follows.
My sample:
Create a measure as follows
Measure = IF(MONTH(MAX('Table'[Date])) <= MONTH(SELECTEDVALUE('Date'[Date])), 1, 0)
Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LukeDurrant
I ran the testing as follows.
My sample:
Create a measure as follows
Measure = IF(MONTH(MAX('Table'[Date])) <= MONTH(SELECTEDVALUE('Date'[Date])), 1, 0)
Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is it possible to change it so that i only have to select oct to show Jan - Oct?
You need to select Jan-Oct in the slicer to get it to show Jan-Oct.
Proud to be a Super User! | |