Forum Discussion

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
1 year ago

Current Year and Previous year using slicer selection

Hi Team,   I have a table from which I'm showing data in Clustered Column Chart but my requirement is   If I select 2023 as a slicer value then I need to show data of 2023 and 2022 i.e., Selected...
General Comment
Need Help
Show and Tell
Tips and Tricks
lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
1 year ago

I tried with Date Column but now it's only showing data of 2022 and not 2023 ( On selecting either 2023 or 2024)

PrevYear Check = 
IF (  YEAR ( SELECTEDVALUE ( 'Raw Data'[Sale Date] ))  >= SELECTEDVALUE ( YearKey[Value] ) - 1
        && YEAR ( SELECTEDVALUE ( 'Raw Data'[Sale Date] ) ) <= SELECTEDVALUE ( YearKey[Value] ),
    1,
    0
)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, lovishsood1 

 

Can you provide your example data or example files? And if there is sensitive information please remove it in advance.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.