@lisanneAsked
Good morning! It sounds like you want to conditionally show the down arrow in your filter based on the number of options available. While Power BI doesn't have a built-in feature for directly achieving this, you can use a workaround using DAX expressions and buttons to simulate this behavior. Here's how you can do it:
1. **Create a Measure:** Start by creating a measure that calculates the count of options available in your second filter. You can use the DISTINCTCOUNT function to count unique values in a column. For example:
```DAX
OptionCount = DISTINCTCOUNT(Table[Column])
```
Replace `Table` with the name of your table and `Column` with the column containing the filter options.
2. **Create a Button:** Insert a button onto your report canvas from the Visualizations pane. This button will serve as the down arrow for your filter.
3. **Set Button Visibility:** Go to the Format pane for the button. Under the General section, you'll find an option for "Button text." You can use the `OptionCount` measure you created earlier to dynamically control the visibility of the button.
4. **Use DAX to Hide Button:** You can use a DAX expression to control the visibility of the button based on the count of options. Here's an example:
```DAX
ShowButton = IF([OptionCount] > 2, TRUE(), FALSE())
```
This DAX measure will return TRUE if there are more than two options available in your filter, and FALSE otherwise.
5. **Configure Button Actions:** Once you've set up the button visibility, you can configure actions for the button. For example, you can use the "Bookmark" action to navigate to a different page or section of your report where the second filter is located.
By following these steps, you can conditionally show the down arrow button for your second filter based on the number of options available. While it's not a direct feature in Power BI, this workaround should achieve the desired behavior for your dashboard.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
