pending Qty

[Skesharwani]

hi team

I have pending data. I want see all pending data except current month

Data

Oct-22

Nov-22

Dec-22

Jan-23

for ex. If current month is Jan-23 So I want Dec, Oct & nov Pending Data

 if i select Dec Then I want Nov & Oct Pending data

[pratyashasamal]

Hi @Skesharwani ,
Please Follow these steps:-
1)First, we need to create a disconnected dimension which will be a copy of the dimension used as a slicer, “Month/Year” in my case.Make sure this dimension table is not connected to other table.(do not have any relationship with any other table ) .Now add the column from this disconnected table to slicer.
2)Create this measures:-
isExclude = IF( MAX(Table[Month/Year]) IN ALLSELECTED('Disconected Month/Year'[Month/Year]) && COUNTROWS(ALLSELECTED('Disconected Month/Year')) <> COUNTROWS(ALL('Disconected Month/Year')), 1, 0 )

or

isExclude =SWITCH( TRUE() ,ISFILTERED('Disconected Month/Year') && VALUES(Table[Month/Year]) IN VALUES('Disconected Month/Year'[Month/Year]),0,1)

The first condition checks which rows should be excluded and the second condition is only used to prevent the measure to exclude everything when nothing is selected.

3)Now use this measure in visual level filter .
You can also follow these link :-
https://datakuity.com/2019/06/13/power-bi-exclude-data-based-on-slicer-selection/

https://www.youtube.com/watch?v=1SnELZGveYs

Thanks ,
Pratyasha Samal

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C