Forum Discussion
Conditional text column based on slider's value
Hi,
I've been asked to create a dynamic client classification in a PBI table.
The table lists clients and shows the sum of their sales in selected time period.
I need to create a new column showing "managed" or "unmanaged" depending on how many units a client sold.
Now the trick is that the requester wants to have a slider with which he could change the criteria amount at will.
One moment he wants everyone above 20pcs to be managed, and two minutes later he wants to change it to 30pcs.
So:
The amount sold will be affected by the time period, product type etc. chosen at the moment.
And the column IsManaged is affected by the slider's amount compared to the sold amount.
The range on the slider doesn't have to be big. Something like 0-100 should be more than enough.
Thank you in advance for your help!
Hi bartosz_lukasia ,
Have you tried looking into What-If Parameters in Power BI?
Check the following blog on this to get an idea how you can use it in your scenario:
https://www.absentdata.com/power-bi/parameter-power-bi/
Thanks,
Pragati
2 Replies
- Pragati11Super User
Hi bartosz_lukasia ,
Have you tried looking into What-If Parameters in Power BI?
Check the following blog on this to get an idea how you can use it in your scenario:
https://www.absentdata.com/power-bi/parameter-power-bi/
Thanks,
Pragati
- bartosz_lukasiaRegular Visitor
Thanks, Pragati,
I had to dig really deep to understand that I had to utilize measures and not columns, as I initially thought, but I did eventually make it all work. Of course the what-if parameter was also really helpfull, but it was only a part of the solution to my problem.
Anyway,
Thanks again! Case closed.