Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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 :))
Solved! Go to 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
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.
Magic, git it to work. Thanks 🙂
@PuddleRunna , Not very cleat. But if you are trying to use a measure or slicer value in new column, that will not work
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |