Forum Discussion
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
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
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
Anonymous
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/38490Paul
