Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Custom filtering by dimension

Hello Wonderful Community,


I have a functionality question that maybe some of you know the answer to.


I have a dataset with an (index) set of days that go from 0 to 250 for each location.  The index restarts at 0 for each location. Is it possible to have a custom filter where I can select which index number I want per location? because if I filter out e.g day 90 then it goes away for all locations. 


Something like


CA 1,23,50,54

TX 9,85,230,250


and so on? and show as matrix or table?

Community Support
Community Support


We also need a sample data table, not just the visuals. The best way is provide a sample pbix.


Read this post to describe your sample:



Super User IV
Super User IV

I expect it is possible in the query editor, but please provide an example of your input table and what the output table should look like.



Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube



Well I was thinking more from a visual stand point as this is a for the end report user. So doing it from power query will require parameters which will be complicated for the user to use once published in the service.


But basically 


Visual filter where I could say for TX give me these numbers and for CA these numbers display the data accordingly


Select Days In        Select Days out


Pick Days (


Pick Days


Visual matrix


Day In Day out Price

30      200          10

45      170          25

15       244         5



Day in Day out  Price

44        125         7

20         75          12

22         250         6

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors