Forum Discussion
Challenging: Filter a column, which should be picked using multiple slicers
Is there any reason you can't have your numeric columns formatted instead as two columns (attribute / value) pairs? Can these numeric columns be unpivoted in other words?
Using this method, you could simply use the Numeric column for your slicer. Then you can use a "between" slicer for your Value column.
Is there any reason you can't have your numeric columns formatted instead as two columns (attribute / value) pairs? Can these numeric columns be unpivoted in other words?
Using this method, you could simply use the Numeric column for your slicer. Then you can use a "between" slicer for your Value column.
That's exactly how I have solved for it currently. However, there are a few issues that I face in this approach.
1. The dataset that I have becomes humungously large if I club those 15-20 columns into a single column, and PowerBI becomes slow to process the visulisation changes.
2. As data gets filtered at row-level for a single column value in this approach, there's a problem to create stacked charts or other visuals where I need 2 or more of those numeric columns as values.The field parameter can let you switch the selected column. However, it is not supported to apply a numeric range filter on it to filter the selected column. An explicit filter requires pointing to a specific column with the column name.
Another option is to use a measure to filter the values. Since you have 15-20 columns, you may need to deal with 15-20 scenarios separately in SWITCH function and filter table in each scenario too. In addition, a measure can only be used on a visual as a filter. It cannot be used as a page or report filter to filter multiple visuals at the same time.
Sorry I cannot think of other possible or ideal solutions.
Best Regards,
Community Support Team _ Jing
