Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to create custom column for a slicer

Hi everyone,    I am new to PowerBi and have quick question. I want to create new collumn called 'country' that would allow me to put it into slicer and when I select specific country it will updat...
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may try to use SELECTEDVALUE Function and SWITCH Function to create the measure as requested. For example:

    Value =
SWITCH (
    SELECTEDVALUE ( Country[Country] ),
    "a", CALCULATE ( SUM ( Table[AT.BUIL] ) ),
    "b", CALCULATE ( SUM ( Table[AT.BUIL2] ) )
)

     

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Cherie, 

 

I was thinking about creating relationship between dates, however since I linked data from a excel file that is on my onedrive, all the manage relationship buttons are greyed out in pbi desktop. So either have to find a work around or go to the initial excel file and try to do change there. 

 

 

I would appreciate any advice on that. 

 

Regards, 

Arnold