Slicer and Filtering

[tom-lenzmeier]

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

[SwarnaTeja]

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.

[tom-lenzmeier]

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.

[SwarnaTeja · Accepted solution]

Got it.

Can you try creating a field parameter as below.

Then add them to the slicers to achieve below.

[SwarnaTeja]

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.

[tom-lenzmeier]

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.