Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthanks! you are amazing!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |