Forum Discussion

sivarajan21's avatar
sivarajan21
Post Prodigy
2 years ago
Solved

Field Parameter button selection shows nothing in visual

Hi,   I have 2 field parameters that filters a visual like below: The one field parameter acts as a main and other acts as sub. Main will have only 2 buttons one for target and another for ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rbriga's avatar
    rbriga
    2 years ago

    I see the problem.

    You're slicing by the field "Category Main" {budget, target}, but Carbon in the Parameter tables have no "category main".

    Thus, you're filtering "carbon" out.

    You won't even see "carbon' in [actual], because  "Category Main" filters your "Parameter 2" table.

     

    If you're going to slice by "category main', you can't leave that field empty in your parameter tables for "carbon".

     

    It's hard for me to offer a fix because the logic is a little hard to follow, but this is the problem.

     

rbriga's avatar
rbriga
Impactful Individual
2 years ago

Selecting the value of a field parameter may require something other than SELECTEDVALUE().

Following this SQLBI article , try this pattern:

 

1	VAR __SelectedValue =
2	    SELECTCOLUMNS (
3	        SUMMARIZE ( Parameter, Parameter[Parameter], Parameter[Parameter Fields] ),
4	        "Row",Parameter[Parameter]
5	    )
6	RETURN IF ( COUNTROWS ( __SelectedValue ), __SelectedValue )

 

  

This will replace your SELECTEDPARAMETER variable.

  • sivarajan21's avatar
    sivarajan21
    Post Prodigy
    2 years ago

    Hi rbriga ,

     

    Thanks for your quick response!

    I tried implementing by replacing my var with above solution you provided but still its not showing carbon

     

     

    Thanks in advance!
    Ahmedx marcorusso amitchandak