Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi Everyone,
I'm a brand new Power BI user, and I'm completely lost.
I created a dashboard for work, where it creates a scatter plot based off the user's choice of an x and y axis. I created two parameters based off of fields for the x and y axis. I want to be able to create conditional formatting so that based off of the chosen y axis either a y axis constant line appears, or the markers of the scatter plot change based on the y axis criteria. Is this possible?
I appreciate all and any help.
They can help me with this concern that I have not known how to solve it is power BI or excel .... or a video where you can solve this task....
I have an inventory as indicated in the image 1000 units of a reference XX
But in x dates they entered 500 units at unit cost $ 200, then entered 300 units at a cost $ 300, then entered 800 units but to equal the 1000 units of inventory I only need 200 units that were at a cost $ 200
and then multiply quantity x unit cost and add all those costs and divide it by the units of the inventory bone the 1000 units and take the real cost in this case $ 230
The comparison is row x row that I would use with the iterator X: SUMX, but knowing that I must match the quantities to the inventory bone to 1000 units as I can say to power BI q of those last 800 units q entered I only need 200 units to match the inventory q were 1000 units.
I do not know if I made myself understood,,,, in advance I thank you if you can help me I have reviewed videos on youtube I can not find the solution.
Attached image in case anyone can help me.
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 139 | |
| 129 | |
| 61 | |
| 59 | |
| 57 |