Forum Discussion

PowerBiTech's avatar
PowerBiTech
Frequent Visitor
2 years ago

convert tableau parameter into power Bi

Hi, 

 

I have to migrate a tableau parameter into power bi. 

In dropdown its display as "Include" and "Exclude" and values are 1 , 0.  and datatype should be whole number.

How to achive this in power bi in the existing table ?

 

 

 

Attached the reference image from tableau. 

 

Please someone explain how to achive this in power bi.

Greg_Deckler amitchandak lbendlin xifeng_L Ashish_Mathur 

 

Thanks in advance 🙂 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    PowerBiTech it depends where you are going to use it, if it is going to be used as a slicer, you can create a table with two columns, display as and value, use display as in the slicer and the following measure to get the value:

     

    Measure = SELECTEDVALUE ( YourTable[ValueColumn] )
  • PowerBiTech's avatar
    PowerBiTech
    Frequent Visitor
    2 years ago

    Hi parry2k Im using this in dropdown and the values are in the another calculated column. if dropdown value is selected as Include and it should be reflect as 1 in the calculated column.