Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
zlus
New Member

Conditional Formatting while using Parameters

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.

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

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.

AlejandroG_0-1691542197541.png

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.