Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |