Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

macmy034

If several filters are passed through to drilldown page - the "first" element is chosen...

Submitted by Resolver I on ‎12-20-2022 04:01 PM

If several filters are passed through to drill down page - the "first" element is chosen when using the value in a "Selectedvalue" function within a Textbox value.

 

Ie - To show what the user has selected within drilldown in a textbox, if several are available - PowerBi resorts to the first value in the list. As opposed to saying "Several". 

 

The value coming from the SelectedValue function is actually blank, using Dax with IF ( ISBLANK ( Measure ), "Several", Measure ) Still returns the first value in the selected value list. Can this be corrected please :).

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-21-2022 11:39 PM

Hi @macmy034 ,

 

 

I don't quite understand your question, but it seems to sound like a limitation of the function itself.I don't quite understand? your question, but it seems to sound like a limitation of the function itself.The value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult.

 

SELECTEDVALUE function - DAX | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses