Thank you first.
I am trying to create a Financial Reporting for a client.
I have followed the Course on Financial Reporting that gave me a lot of useful information.
I have set up a specific template and created the measure to populate the template (attached the pbix for Profit and Loss).
I would request your help in doing the following actions:
1. If a value is empty put “-”, instead of blank
2. Is it possible to group the some rows to get a smarter PL scheme? For example, I would like to group the red rows reported in the attached .png image.
3. Is it possible to highlight also some specific rows of the PL (e.g. “Revenues”, “Contribution Margin”, “Clinic EBITDA” etc). I tried the SWITCH function, but did not work. I was able to highlight only the number part as you can see.
Thanks a lot for your support.