Conditional filter in "Power Apps visual for Power BI" when no filter is applied to Power BI

[Anonymous]

Is it possible to set a default filter in a "Power Apps visual for Power BI" while no other filters are applied in Power BI?

Example: Leave the visual showing only today's data, but if any filter is selected in Power BI, the Power BI filter is used and today's filter is not.

[Anonymous]

I believe I have found a solution. We can send a measure as a column to Power Apps Through Power BI, so we just create a measure that checks if the table has any filters and send it to Power Apps, as the example below shows:

(NOTE: I did the calculation this way because functions like "HASONFILTER" are filtered inside a table using a measure!)

After that, just connect the original data source within Power Apps, in this case SharePoint, making a conditional like: if any Power BI filter is active, use it as a database, otherwise, use SharePoint.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, or how your expected outcome looks like, but I tried to create a sample like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

QTY expected result: =
IF (
    ISCROSSFILTERED ( Sales ),
    SUM ( Sales[Quantity] ),
    CALCULATE (
        SUM ( Sales[Quantity] ),
        KEEPFILTERS ( 'Calendar'[Date] = TODAY () )
    )
)

[Anonymous]

Very good explanation, but it wasn't exactly that, more because I didn't explain it properly, sorry. My real scenario is the following: I have a base of items that are filled daily, in order to generate a good history, so I have a report to display this information. I want to put a Power apps inside the report, so I can fill in the items daily too, the items are generated automatically by a Power Automate flow, so no worries about that. So, I wanted to send the data from Power BI to Power Apps, so that if no other filter is selected in the report, the values ​​returned to Power Apps are only the ones with today's date, if any filter in the report is selected this is no longer valid and the report filter prevails.