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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.