Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
6 years ago
Solved

Button with filter

Hi all,   A question; Is it possible to set filters for a button? For example, I want 2 buttons that if the value is one the button will turn red and a button if a value is two the button will ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Frixel 

     

    Do you mean you connect the onedrive data source on desktop and publish it to the service?

    The dataset should be synced from Onedrive every one hour by default. but if you made changes on the onedrive, you should refresh the dataset and report in the service manually. note that you should refresh the web page if you'd like to see the latest updates in report.

     

Melvlee's avatar
Melvlee
Helper I
6 years ago

Hi Frixel ,

 

Not sure what visual you would like to use.

I can show you what I did with a table visual.

 

1. I created a measure which returns a circle symbol based on the status.

 

StatusIcons =
VAR _result =
    SELECTEDVALUE ( Status[Status] )
RETURN
    IF ( _result = "1", "CircleSymbolLow", "CircleSymbolHigh" )

 

2. Set up conditional formatting of Icons for Status field.

  

 

 
 
 

3. Here is the outcome.

 

Best Regards

 

 

 
 

 

Frixel's avatar
Frixel
Post Prodigy
6 years ago

Hi Melvlee 

 

Thanks for your answer but a question.

 

is this also possible in the service version with i work?

Where and how do i set this?

 

StatusIcons =
VAR _result =
    SELECTEDVALUE ( Status[Status] )
RETURN
    IF ( _result = "1", "CircleSymbolLow", "CircleSymbolHigh" )

 

  • Melvlee's avatar
    Melvlee
    Helper I
    6 years ago

    Hi Frixel ,

    That is a measure you need to create.

    Unfortunately, you are not able to create new measures in Power BI Service.

    It has to be done in PBI desktop.

     

    Regards