Power BI/DAX using parameters

0
votes

I'm a bit new to the DAX/Power BI, so i dont have broad understanding of it.

I have table 'Sales' as follows:

ItemID     SalesValue     Amount     actionSales        Date
   1          0.5           2             0          2018-02-18
   1          0.3           5             1          2018-02-18
   1          0.5           6             0          2018-02-19

-I left out some fileds as description, brand, etc...

-actionSales field is a bit, that represent if sold item was on a discount.

I have made few measures that have total salesValue, total salesValueOnActionSales, percentOfActionSales, etc...

Within visuals in Power BI I can filter values if they are greater or lower then some value.

Then i figured that it would be nice to show only items that have share of action sales greater then 'parameter' (Parametr is a whole number, and it is in visual with a slider) that I made on a report.

After some time, I'm no closer to a solution. Can this be made? if it can, can someone please point me to a direction on how to do this or share some insights on the matter.

Cheers

2
powerbidax

2 Answers

2
votes

This can be done with the 'What If' parameter in PowerBI. In short: you define a parameter, connect it to a slicer and use the parameter in a measure.

Link to MSDN Docs

0
votes

Can you not add the actionSales column to a slicer and select Greater than or equal to from the options?

If this doesn't work let me know and I have another solution that might do it.