Forum Discussion

Skesharwani's avatar
Skesharwani
Regular Visitor
3 years ago

pending Qty

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

 

Need Help

1 Reply

  • pratyashasamal's avatar
    pratyashasamal
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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