Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to create a calculator function in Power BI? Ex. "add inputs or select inputs from a drop down to get outputs based on criteria". I have something like this in Excel but my data is currently static and needs continuous updating. Would love to be able to do something like this in Power BI as my data refreshes daily.
Solved! Go to Solution.
I haven't any resources for what you want to do.
But as I have mentioned before, you can implement your inputs as filters with slicer, for example, and your outputs with measures or calculated columns and exhibit them with card, for example.
If it helps, I appreciate a kudo.
Can someone gives an update? Has someone a better idea than using slicer ander filters? If you consider a range of 1000 $ you get 100000 rows 😣...
Hi
Yes that's possible if I understand properly what your question means. Could you please be more specific in defining what you want to implement in your report, so that we can help?
Thank you
Hi,
Probably it is possible. Can you share an example of what do you need to implement in the PBI?
@mauriciosotero @saraMissBI @santiagomur This is what I was looking to recreate. Does this help at all?
It helps a little. In your example the inputs will be the filters of your report and the outputs will be the calculated measure or columns.
Have you started to implement in the PBI? Have you already imported your data to the PBI?
Data is imported. Have not begun to implement - not sure where the best place to start is.
If you haven't implemented any report ever, I suggest, first, you take a free course in the Edx:
https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi-3
For me, it is the fastest way to learn PBI.
Thank you! Do you know of any resources like this for building a calculator type function like the one I am looking to build? I have some familiarity building visuals already.
I haven't any resources for what you want to do.
But as I have mentioned before, you can implement your inputs as filters with slicer, for example, and your outputs with measures or calculated columns and exhibit them with card, for example.
If it helps, I appreciate a kudo.
if i understand your question.
try to use on the desktop <Modeling> <New Parameter What IF> with this you can create inputs to your measure or calculations.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |