Formatting a table visual

[Anonymous]

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?

@Greg_Deckler @MaryF @MFelix @amitchandak 

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

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

[v-deddai1-msft · Accepted solution]

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