Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |