Forum Discussion
Slicer and Filtering
Hello,
I currently have a dashboard that has a customer-based slicer from the dimension table. Currently there as 2 columns in play called EA1 & EA2. They all reside in the dimension table. I've been asked to add a third column to the mix. The problem is that I am currently using N/A for all the blanks, having replaced blanks with N/A for each. If I add a third column, the user will have no way of easily getting to the value they're looking for since there would be too many N/As. My idea is to have a button slicer that will return one of the 3 values from the table to another slicer. I'm kind of stuck on how to do this other than using bookmarks, which I'd just as soon avoid. To summarize, there are 3 columns in play. Each column has numerous blanks (now N/A). Instead of having a slicer for each, I'd like 2. A button, or something like it, and then the slicer with the corresponding columnar values. Any help would be appreciated.
The table looks something like this
EA1 EA2 Primary
C1 blank blank
blank C2 blank
blank blank C3
Got it.
Can you try creating a field parameter as below.
Then add them to the slicers to achieve below.
5 Replies
Hi tom-lenzmeier ,
Is the issue is when user use the slicer he has to slide through many blank values to reach the required value? I am wondering if a text slicer would help as they can search with first letter of the value.
I am sorry if I didn't get your point correctly.
It is I who am unclear. The 3 columns are all text fields with customer long names in each. Some of the values on the rows are null or blank. Two of the columns are related --> EA1 & EA2. The third is not really related and can't be nested practically speaking.
Again I am just trying to guess if you are thinking to use only one slicer for all 3 columns instead of 3 different slicers. And a buttoon to select the column that the slicer should display.
I suggest create a field parameter and add it to the slicer so that you will get toggle to select the required column for the slicer.
One slicer that shows the distinct values from the dimension based on whether they choose EA1 or EA2 or Primary IDN from a button type slicer.
Got it.
Can you try creating a field parameter as below.
Then add them to the slicers to achieve below.
