cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
reynags91
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
V-pazhen-msft
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
 
mahoneypat
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
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

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.