Need help for a custom visualization

vmurali1 — Tue, 06 Sep 2022 14:27:10 GMT

Hey,

I am looking to do a conditional formatting in a matrix visualization based on a text column. Here is a sample below:

Vendor	Jan	Feb	March
TMZ	100	$200	100
STR	200	$300	400

I've included the contract status (Contract / No Contract) and item description under the rows.

To provide a picture, there will be a plus(+) sign right next to the TMZ and STR. When you click it, it drills down to contract status and different items purchased from the vendor. The cumilative dollar amount is what you are seeing above. One might have purchased $20 worth of non contracted item and $80 worth of contracted item which brings the total to $100
I am looking to do a conditional formatting for the months where i should be able to see 80% (for contracted item purchases) green and 20% red (non contract purchases) keeping the dollar value same ($100).
IS there a way to do this ?

Thanks in advance

Re: Need help for a custom visualization

Anonymous — Wed, 07 Sep 2022 08:45:25 GMT

Hi @vmurali1 ,

I'm not clear about your requirement. Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Especially please explain how do you want to configure conditional formatting base on your sample data. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

And you can refer to the following link to configure the conditional formatting.

Apply conditional formatting in tables and matrixes

How to Apply Conditional Formatting in Power BI Tables

Best Regards

topic Re: Need help for a custom visualization in Developer

Need help for a custom visualization

Re: Need help for a custom visualization