Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a problem and not sure if power bi is able to do it. Basically , I have been creating a column with the formula below for each category. It is to set limits to see how many transactions and the total expense for the over and under limit transactions.
Formula:
Solved! Go to Solution.
Hi @darrylwjk,
It is not possible to create a text box where you can enter the limit which is then feeded back to the data model. A workaround that I can suggest is to create a table having a column which is set to have a range in which your limit might lie. Then you can use that column as a slicer. That should do the trick.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
Hi @darrylwjk,
It is not possible to create a text box where you can enter the limit which is then feeded back to the data model. A workaround that I can suggest is to create a table having a column which is set to have a range in which your limit might lie. Then you can use that column as a slicer. That should do the trick.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
User | Count |
---|---|
85 | |
84 | |
71 | |
65 | |
57 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |