Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Formatting a table visual

I am using a table visual which has location names and other columns and I also have a unichar ,

ButtonUnichar = "🔘"
Now, I want this unichar to change, which is indicating a selection is made, when a value is selected on the table, how to achieve this?
 
I cant use a hasonefilter on this table, because all the values are from measures, how to achieve this?
 
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    A little modification to selimovd's answer  :

    myUnicharMeasure =

VAR vSelectedValue = COUNTROWS(VALUES(mySlicer[SlicerValue]))
VAR ButtonUnichar1 = "Unichar Value 1"
VAR ButtonUnichar2 = "Unichar Value 2"
RETURN
IF(vSelectedValue = 1, ButtonUnichar1, ButtonUnichar2 )

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    try the following measure:

    myUnicharMeasure =

VAR vSelectedValue = SELECTEDVALUE(mySlicer[SlicerValue])
VAR ButtonUnichar1 = "Unichar Value 1"
VAR ButtonUnichar2 = "Unichar Value 2"
RETURN
IF(vSelectedValue = 1, ButtonUnichar1, ButtonUnichar2 )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

      thanks for your help selimovd , I am getting the above error, can you please help.

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        A little modification to selimovd's answer  :

        myUnicharMeasure =

VAR vSelectedValue = COUNTROWS(VALUES(mySlicer[SlicerValue]))
VAR ButtonUnichar1 = "Unichar Value 1"
VAR ButtonUnichar2 = "Unichar Value 2"
RETURN
IF(vSelectedValue = 1, ButtonUnichar1, ButtonUnichar2 )

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai