Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a simple table visual as illustrated below. The goal of this table is to show which Codes meet the criteria defined in the three slicers shows on the same page (Metric1 and Metric2 are Between slicers, Status is a simple Dropdown)
Code | Metric1 | Metric2 | Status |
Red | .6 | 500 | A |
Green | B | ||
Blue | .4 | 6000 | A |
The issue I am running into is when I change the Metric1 or Metric 2 slicers to anything that doesn't include 0 in the range, everything that has a Status of B is filtered out of the table visual.
I'm not sure how a solution would be crafted, but the ideal output table keeps all records with Status B, regardless of what ranges the Metric slicers are adjusted to and only adjusts the records for Status A.
Hi @palchaw ,
Could you provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples? Later we can create a measure as below to replace the original calculated column to get the expected result. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
Best Regards
In your example, would this involve creating a separate table called "Slicers" that has two columns, one for each Metric, and two records, one with the Max and one with the Min? Is a relationship required between this new table and the main fact table?
Example:
Metric1 | Metric2 |
0 | -10,000 |
1 | 10,000 |
Try this:
Metric Filter Measure =
IF(
SELECTEDVALUE('Table'[Status]) = "B",
1,
IF(
'Table'[Metric1] >= MIN('Slicers'[Metric1 Min]) &&
'Table'[Metric1] <= MAX('Slicers'[Metric1 Max]) &&
'Table'[Metric2] >= MIN('Slicers'[Metric2 Min]) &&
'Table'[Metric2] <= MAX('Slicers'[Metric2 Max]),
1,
0
)
)
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |