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, i'm trying to get a filter that automatically selects me two field,
example, I want if I select the "TOWN HALL" field, the other corresponding field "TOWN HALL - TEMPERATURE" is automatically selected,
some idea? Is it possible to create a filter with a query?
I would recommend you to enable "Search" option on your slicer and type "Town Hall" in search bar then select required fields related to Town Hall.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
Yes @Tahreem24 ,
Good solution also.
If you want to go down the Calculated column route the following DAX should work for you.
thanks for the tip but it can't work for me, because they can be given for example:
TOWN HALL 1
TOWN HALL 2
TOWN HALL - TEMPERATURE
If I select 1 I must restore 1 + temeratua, and if I select two I must take 2 + temperatures
I would consider a new calculated Column that incorporates a high level common factor between the 'xxx' & 'xxx - Temparatura'. Then you would slice/filter based on the high level column.
Let me know if you are unsure.
Regards, sduffy
it can't work for me, because the table is always updating with new values
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |