cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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?

3 REPLIES 3
Community Support
Community Support

@reynags91 

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:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Paul

Spoiler
 
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.

Regards,

Pat





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


Hi,

 

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

Filters: 

Select Days In        Select Days out

TX

Pick Days (

CA

Pick Days

 

Visual matrix

CA

Day In Day out Price

30      200          10

45      170          25

15       244         5

 

TX

Day in Day out  Price

44        125         7

20         75          12

22         250         6

Helpful resources

Announcements
secondImage

Congratulations!

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!.

secondImage

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