Dynamic Filter

[Anonymous]

Hi Everyone,

I wanna know if this is possible to do in Power BI and if it is can tell me how?

so this is the case:

i have "Ly sales variation" of this 5 stores, where "ly var" is a calculated measure and i wanna create a filter like this, that allows me to filter the stores according to the Ly Variance result

Note: Ly Var cant be a column in my database

Also sorry if the tittle is not appropiate to what im asking, i didnt know how to name this thread

[MFelix · Accepted solution]

Hi @Anonymous ,

Create the following table:

	Variance Filter	Max	Min
1	>=105%	999999	1,05
2	>= 100% & < 105%	1,04999	1
3	< 100%	0,99999	0

Now add the following measure:

Filter Variance =
IF (
    HASONEVALUE ( 'Variance Filter'[Variance Filter] );
    IF (
        [LY Variance Sales] >= VALUES ( 'Variance Filter'[Min] )
            && [LY Variance Sales] < VALUES ( 'Variance Filter'[Max] );
        1;
        BLANK ()
    );
    1
)

Now add the Column Variance Filter as a slicer and the measure as a filter on your visual then filter all values equal to 1 this should give expected result.

Check PBIX file attach.

Regards,

MFelix

[Anonymous]

thanks! you are amazing!