I have Power BI report having some filters implemented on columns. Now I have to add a new filter on the basis of measure, I have data in the following format for that column, +ve integer
, -ve integer
or 0
.
What I'm trying to achieve, there should be a filter with three default values (+ve integers
, -ve integers
and 0
).
When I select +ve
, it should show only records having +ve
integer values and so on for two other cases.
Problem: I am creating measure from a measure but not getting the exact data from it.
The second thing I did was created a measure of positive and negative, I am getting the exact data if I will use in table visual but not in the slicers form.