cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nzcatala
Frequent Visitor

Slicers that adjust based on each other

Here's a simplified version of what I'd like to see in my report.

 

 

ID_Table

ID   Outages

1    3

2    2

 

The "Outages" Column would be calculated with something like:

=CALCULATE(COUNT(Outage_Table[ID]),ALLEXCEPT(ID_Table,ID_Table[ID]))

 

Outage_Table

ID   Date

1    8/9/2018

1    8/10/2018

1    8/11/2018

2    8/9/2018

2   8/10/2019

 

What I would love to see is having two filter, one that allows me to adjust the number of outages, so that I can see all customers with more than 4 outages for example, but I would also like to be able to say "How many customers have had 4 or more outages in the last 3 months"

 

 

Because I'm using a calculated column, it doesn't adjust based on the filter.  Is there a good workaround?

1 ACCEPTED SOLUTION
Joorge_C
Resolver II
Resolver II

I think the only way to do this is have Columns and not meassures in a hierarchy table sort of say.

 

If you do all this in Excel and upload your final table for a full year of data, then you could have the different values accross slicers and all would be in sync

View solution in original post

3 REPLIES 3
Joorge_C
Resolver II
Resolver II

I think the only way to do this is have Columns and not meassures in a hierarchy table sort of say.

 

If you do all this in Excel and upload your final table for a full year of data, then you could have the different values accross slicers and all would be in sync

View solution in original post

I figured as much.  Thanks for the help!

@nzcatala,

 

You may also take a look at https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors