cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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 turn green.
Or is that also possible with visualizations, although I have not been able to find that.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Button with filter

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

11 REPLIES 11
Highlighted
Memorable Member
Memorable Member

Re: Button with filter

Hi @Frixel ,

I guess my workaround would be create a table in which I color the fields with conditional formatting. Than I would use a drill thourgh button to enable the row in the table and after that I klick on the drill through button to get more informations. But this is only one option 😄

 

Best,

Kathrin

Highlighted
Post Patron
Post Patron

Re: Button with filter

Hi @KBO 

 

I think i don`t understand you.

When i do like this everything is red, also status 2.

 And what do you mean with "klick on the drill through button to get more informations'"

 

1.png

Highlighted
Helper I
Helper I

Re: Button with filter

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.

  

Melvlee_1-1594517300629.png

 

 
 
 

3. Here is the outcome.

2020-07-12_11-52-28.png

 

Best Regards

 

 

 
 

 

Highlighted
Post Patron
Post Patron

Re: Button with filter

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" )

 

Highlighted
Helper I
Helper I

Re: Button with filter

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

Highlighted
Community Support
Community Support

Re: Button with filter

Hi @Frixel 

 

kindly check the attachment whether help.

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Post Patron
Post Patron

Re: Button with filter

Hi @v-diye-msft 

 

Thanks for the button.

Can i import it in a existing report in the service version?

Highlighted
Community Support
Community Support

Re: Button with filter

Hi @Frixel 

 

Sorry you can't, you should download the report as pbix from the service and implement the changes before republishing it. cuz data modeling is not supported in power bi service.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Post Patron
Post Patron

Re: Button with filter

Hi @v-diye-msft 

 

Do you know why I use the desktop service to make a report of a file that is on one drive and publish it.
That in the service version the report is not directly updated with the onedrive connector if an update to the file has make?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors