Column Formular doesn't work properly

[ShanaiJin]

I had VAR column formula as below and it works perfectly in before , but now it doesn't work:

Formula : IF(RowHeader()=="Margin %","",IF(RowHeader()=="OPEX",Budget-Actual,IF(Row().style=="stylesSubtotal",Actual-Budget, VAR)))

Can you check what may cause this issue ? Thanks ! Best Regards Shanai

[AndersAano]

Hi @ShanaiJin,

It seems the rows have lost their style.

Could you see if these steps help?

Try these steps:

1. Search for "Outline" in the format pane of the visual (this will return all outline fields)
2. Scroll through and look for any blank fields.
3. If blanks, select any other option.

You can see in my screenshot I have a blank outline field under Values Formatting:

Change all blank you find in the option, and set them to something else, or just "none". Then all should work.

Best regards Anders

[ShanaiJin]

Hi Anders ,

I had tried to set the outline format under value with "None" , but the problem is still there .

I tried to reinstall both Power BI desktop and ProfitBase , but the problem can't fixed , it is still lost the style .

[cid:fcb87b78-b132-400e-99d4-f070e1132180] [cid:571f80e6-17bd-412f-be49-03e1ed23048a]

Any suggestions to solve this problem? for old version [cid:88c797c5-f5f6-4b00-b818-10e8186e3a62] is no problem . [cid:13b08931-4aad-482b-bb39-6434ed1f44fa]

Thanks,  Shanai

---

From: Anders Aano @.> Sent: Monday, February 19, 2024 10:16 PM To: Profitbase/PowerBI-visuals-FinancialReportingMatrix @.> Cc: Shanai Jin @.>; Mention @.> Subject: Re: [Profitbase/PowerBI-visuals-FinancialReportingMatrix] Column Formular doesn't work properly (Issue #572)

Hi @ShanaiJinhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ShanaiJin&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=BtG_3mp4g-xvro-eqoRKGXnOTgMYKdhfBwV6cZ4F0mI&m=ZNKsU5Rwf9BdeXC7ReTVYptMKSJNz-0TVH6ih02ySZgvenaxTPXwsMMXI6LwvAJ2&s=mNpSmT2wmf3OTuJOzjybkdVTBE48C43fat-8yEBjhYI&e=,

It seems the rows have lost their style.

Could you see if these steps help?

Try these steps:

1. Search for "Outline" in the format pane of the visual (this will return all outline fields)
2. Scroll through and look for any blank fields.
3. If blanks, select any other option.

You can see in my screenshot I have a blank outline field under Values Formatting:

image.png (view on web)https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Profitbase_PowerBI-2Dvisuals-2DFinancialReportingMatrix_assets_82056309_94e4811e-2D40be-2D427a-2Da8ad-2D1fb98f1f263c&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=BtG_3mp4g-xvro-eqoRKGXnOTgMYKdhfBwV6cZ4F0mI&m=ZNKsU5Rwf9BdeXC7ReTVYptMKSJNz-0TVH6ih02ySZgvenaxTPXwsMMXI6LwvAJ2&s=JBJzDTJ6WEHfwVkmY8zJJrN93ljmZTCyWCW-bG0WhWY&e=

Change all blank you find in the option, and set them to something else, or just "none". Then all should work.

Best regards Anders

— Reply to this email directly, view it on GitHubhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Profitbase_PowerBI-2Dvisuals-2DFinancialReportingMatrix_issues_572-23issuecomment-2D1952541455&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=BtG_3mp4g-xvro-eqoRKGXnOTgMYKdhfBwV6cZ4F0mI&m=ZNKsU5Rwf9BdeXC7ReTVYptMKSJNz-0TVH6ih02ySZgvenaxTPXwsMMXI6LwvAJ2&s=olz_CRw2Zhudt9TLPJeJ7fKRqV7oKrv8aoUJR0WXFkQ&e=, or unsubscribehttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_A6L2NECRCG7G54QDNTSMK6TYUNNCBAVCNFSM6AAAAABDM5JTDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJSGU2DCNBVGU&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=BtG_3mp4g-xvro-eqoRKGXnOTgMYKdhfBwV6cZ4F0mI&m=ZNKsU5Rwf9BdeXC7ReTVYptMKSJNz-0TVH6ih02ySZgvenaxTPXwsMMXI6LwvAJ2&s=x7VlLwTEFnVZze94ccLHrDbdxJSStIuDkjcG76yxD10&e=. You are receiving this because you were mentioned.Message ID: @.***>

[AndersAano]

Hi @ShanaiJin,

Our last version should be available now with a fix. Do you still get his issue?

-Anders