topic Re: Conditional Filtering by URLs in Developer

Conditional Filtering by URLs

Anonymous — Fri, 09 Oct 2020 22:49:15 GMT

I have a sql table that holds estimated and actual values for many projects. I have a power bi report that is using this table for it's data, and i'm displaying it as an embedded report on a webpage. I am trying to use this report to compare the estimated value for the project I'm currently looking at to the actual values of other projects in the table. Is there a way I can filter out all estimated values except the estimated value for the current project i'm looking at?

So far we have been using dynamic URL filters in our power bi reports so that we can reuse the same report for different projects on our website so ideally this could be done with the URL filter somehow.

Thanks!

Re: Conditional Filtering by URLs

lbendlin — Thu, 15 Oct 2020 17:37:35 GMT

URL filters should work. Note that they only override the filter upon page load, after that the user can change the filter back to something else.

What have you tried and where are you stuck?

Re: Conditional Filtering by URLs

Anonymous — Tue, 20 Oct 2020 00:24:19 GMT

I'm unclear on the syntax of how to do this conditional filtering. If I filter based on project id, it would remove all of the "actual" values from the other projects in the sql table. What would the syntax be to only show "estimated" value for a given project ID but also show all of the "actual" values for all other projects with different IDs? The sql table looks something like this

Project ID | Type | Value

1 'Actual' 5

1 'Estimate' 6

2 'Actual' 7

2 'Estimate' 8

3 'Estimate' 4

If the project ID i'm looking at is 3, I would want the power bi visual to show the estimated value for project 3, and the actual values for projects 1 and 2.