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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Top Kudoed Authors