Forum Discussion

bartosz_lukasia's avatar
bartosz_lukasia
Regular Visitor
5 years ago
Solved

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!

2 Replies

    • bartosz_lukasia's avatar
      bartosz_lukasia
      Regular 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.