Show Slicer value or empty in a column

[PuddleRunna]

Hi guys,

I'm stuck on this one, maybe someone can point me in the right direction.

I have a visualized table based on filters set for the page.

Now for this specific set of data I want to be able to see if they have a specific software assigned. That data is available as text in SoftwareAssignment[SoftwarePackage].

I have created a new column "Check Package" as 

Check Package = IF([SoftwarePackage]="Software 1",[SoftwarePackage],"")

It does exactly what I want it to do. It keeps the original data and displays who has it assigned and who doesn't (as empty):

Column A	Column B	Check Package
Functional	14.04.2021 03:01
Functional	14.04.2021 03:01
Functional	14.04.2021 03:01	Software Package 1
Functional	25.03.2021 11:54
Functional	25.03.2021 11:54	Software Package 1
Functional	14.04.2021 03:01

So far so good, I have like 300 Software Packages though, so I need this to be flexible and be able to quickly filter for Software 2 etc.

Sooo, after browsing the net for ages and not finding that ONE solution to my scenario, I have done the following:

1. Put a Slicer on "SoftwareAssignment"[SoftwarePackage]

2. Created a Measure 

Slicer Selection = SELECTEDVALUE(SoftwareAssignment[SoftwarePackage])

(Can't remember anymore why I did that exactly, but it seems to have helped 🙈)

3. Changed "Check Package" to this: 

Check Package = IF([Slicer Selection]=[SoftwarePackage],[SoftwarePackage],"")

Now it does do the filtering dynamically, however it doesn't display the blanks anymore:(

Column A	Column B	Check Package
Functional	21.10.2020 00:33	Software Package 2
Functional	28.03.2021 07:03	Software Package 2
Functional	27.03.2021 12:43	Software Package 2

Appreciate any help on this!

(As a next step I would want that column to display as empty if no selection is made in the slicer, but I think I've seen solutions to this around here already :))

[Anonymous · Accepted solution]

@PuddleRunna 
You need to create a disconnected to be used as the slicer.

1. create a new table with a column: Table = Distinct( 'SoftwareAssignment'[SoftwarePackage])

2. use the new column it as the slicer.

3. create a measure:

Check Package = IF(MAX('SoftwareAssignment'[SoftwarePackage])=Selectedvalue('NewTable[Column]),[SoftwarePackage],"")

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[PuddleRunna]

Magic, git it to work. Thanks 🙂

[amitchandak]

@PuddleRunna , Not very cleat. But if you are trying to use a measure or slicer value in new column, that will not work

[PuddleRunna]

Doesn't have to be a new column. I have no idea on how to realize what I'm trying to do, so that was my first attempt. I'll take whatever will make me achieve this.

What I need is a dynamic way to achieve what I did with the first sample table.

Out of my filtered visual table that has 7 rows, I want to display which of these have Software Package xy assigned while still displaying all 7 rows instead of filtering to just Software Package xy.