Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I wonder if i could pick people brains/skills. I need to produce a report which i intend to enmbed in a public facing website. What i am trying to achieve is for users to be able to input a figure which will return results based on calcuations. the problem i have is that the range of the input is vast ie between 50,000 to 2,000,00 in 5,000 increments. i thought of using a slider however as you all know this is a greater or less than option, a drop down would produce a massive list which i think is unusable etc etc
Has anyone overcome this problem or have any suggestions. Any help would be really appriciated
I hope i have explained myself for you all to understand.
tim
Solved! Go to Solution.
Hi @tmears,
You should use the Parameter table. This will create you a table with an incremental value you want and adding it on a slicer will allow you to make the calculation since the measure is created with the table:
As you can see the New table is created using a formula GENERATESERIES and where you can tweek you parameters if you want to change them in the future.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @tmears,
You should use the Parameter table. This will create you a table with an incremental value you want and adding it on a slicer will allow you to make the calculation since the measure is created with the table:
As you can see the New table is created using a formula GENERATESERIES and where you can tweek you parameters if you want to change them in the future.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |