Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Proud to be a Super User!
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |