POWER BI - Slicers and IF functions.

[Jiří]

Hello everyone,

I would like to ask for an Help. I am trying to implement POWER BI in our company and I am creating new big report. Until now I was able to do everything with the youtube or forum. But now I really don't know how to slove this problem.

I created MATRIX and I have 2 sources for it. Budget file and Actual file. Also I use standart slicers for Months and Expense types filter and now I want to create new slicer that is showimg me 2 possibilities:

1. Overspend. 

2. Planned

For this i thought that this DAX would work:

Kategorie = IF ( SUM('Tabulka1_2'[Budget]) - SUM('ALR'[Actual])> 0,

"Planned", "Overspend" )

But I am not able to assign this DAX to Slicer.

My expectation is that I should be able to set months (April->July), expense types (External services) and also if it is Overspend/Planned in those months adn expense types.

Here is the Matrix 

Can you help me with this PLEASE?

Best regards.

[lbendlin]

Slicers cannot be fed by measures. They can only be fed by columns.   If your measure produces a well known range of values you can use an external reference table with these values predefined.

[Jiří]

Thank you for answer. I am not sure, if I understand you correctly. What do you mean by "well know range of values"? In data I have all details for Budget and Actuals. So everything else works fine. But I need last filter that I can use to see overspends. I cannot prepare this in data since it is changing base on other filters (months, expense types and so on). Do I have any options to do such thing?

[lbendlin · Accepted solution]

I am not aware of any options for that in Power BI.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41