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 have had a request from a work collegue to be able to filter by the value selected in the slicer and a defualt value.
e.g. slicer has A B C D E in it
The selection is C which will filter the data to show C data
However I need to show C data plus Z data (a default value)
Values C and Z live in the same columnin the table
The slicer cant show Z as an option
Please cna nay one help ?
Thank you
Try puting it directly in the filter
Hi That wouldnt work as it needs to be based on the slicer selection plus Z
No worries, will keep digging 🙂
Hello , if you can share some sample it would be better to know what is the issue
Unfortunatley this quite sensitive data so cant actually supply a proper example , so here a mock up
Hi , you can put it in a card or a table ,
for filter just drag and drop anything you want to make filter for it and set the conditions .
hope this worked with you , if not share some sample of the PBIX file to go through it
Hi
I get the following when set up as a measure
Have you tried putting in brackets like (Accounts[Earnout_BoBNAme] = SelectedValue) || (Accounts[Earnout_BoBNAme] = "Z") ?
Sometimes when combining expressions with || the parts associate with a priority that does not match what might be expected.
Sorry but that doesnt work either
Try this :
Filtered_Data =
VAR SelectedValue =
SELECTEDVALUE('Your_Table_Name'[Column_Name]
)
RETURN
FILTER( 'Your_Table_Name', 'Your_Table_Name'[Column_Name]
=
SelectedValue
||
'Your_Table_Name'[Column_Name] = "Z"
)
Thank you for replying.
Would you set this as a measure then add it in to the "Filters on this visual" section
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 | |
99 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |