Excluding a column from a slicer filter

[Anonymous]

Hi,

I am working on a project for school, and i am running into an issue.

We are working with some financial data, and we have 3 different kinds of transactions:

Budgeted, Ordered and Completed.
We are using some slicers to filter the data to different subgroups, and also a date slicer which filters on date.

The Budgeted only has the date of 1-1-2020, the other 2 have all kinds of different dates in them.

My question is, Is it possible to exclude the budgeted column from the date slicer? This so that the Budgeted is always visible, even when there is a date filter active.

[AllisonKennedy]

@Anonymous  Maybe budgeted should be split into its own table so you can view this independently from the other data? This can be done in Power Query - duplicate the query and filter for budget (you can use the filter arrow in Power Query to filter the transaction kind column)

Other option is to create measures for every visual you're using, that update the DAX context to always show the budget, but I think this will be less efficient. I can't say for certain as I don't know much about your report, but I would suggest putting budget in a separate table.

[amitchandak · Accepted solution]

@Anonymous , One way is to stop interaction of budget visual with date. https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Or use all(date) in meausre

calculate(sum(Budget[Amount]), all(date))

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

[Anonymous]

this did the trick for me. Thnx alot!

calculate(sum(Budget[Amount]), all(date))