Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Dear Members,
I am encountering a small challenge in my PowerBI dasboard. I am creating a dashboard with the search profiles of companies. There is one specific text field called 'Need' (see bottom right of the dashboard). This is written text with additional info about a company's search criteria.
Now I would like to create a filter to only show the company's need (bottom right in the dashboard IF only one company from the primary table is selected (large table on the left/middle.
How can I create such as filter?
Solved! Go to Solution.
Hello Robert,
for example like this:
HasOneFilter =
IF(
HASONEFILTER(Tabelle1[Company Name]),
VALUES(Tabelle1[Needs]), "")
in Tabelle1[CompanyName] you look if there is a filter on this, in VALUES(Tabelle1[Needs]) you give the column that needs to be returned when the company name is filtered.
If nothing is selected, return empty.
Does that help?
best
hashtag_pete
Hello Robert,
for example like this:
HasOneFilter =
IF(
HASONEFILTER(Tabelle1[Company Name]),
VALUES(Tabelle1[Needs]), "")
in Tabelle1[CompanyName] you look if there is a filter on this, in VALUES(Tabelle1[Needs]) you give the column that needs to be returned when the company name is filtered.
If nothing is selected, return empty.
Does that help?
best
hashtag_pete
Great, this works perfectly fine! Thank you very much for the help!
Please provide sample data in usable format (not as a picture) and show the expected outcome.
Have you looked into functions like HASONEVALUE() or HASONEFILTER() ?
I have no clue how I should type the measure, to be honest.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |