Calculate data for Rules Based on Field and Drill Through

[Babette]

Still a newbie with Power BI and trying to get some help.

My Survey has a Summary Report and allows users to drill through to open the Detailed Report.  The model is simple  with just Survey Fact and Date Dimension tables.  The Survey Fact table contains all the surveys (1 survey per row), has the Measures: # Survey, # Responses, Responses % etc. I am able to create both reports successfully.

My next task is to add Icons (arrow Up/Down) to indicate Responses % compared to previous quarter.

How can I calculate and use the Conditional formatting (Icons) with Rules Based on Field to create the arrow Up/Down?
Can I also assume users can continue to drill through to open Details Report with the arrow Up/Down in the report?

Thank you in advance for any suggestion you may have to help me.

[selimovd]

Hey @Babette ,

you can add a new measure that comparing your measure to the previous quarter measure.

Then you can say if it's greater the symbol should the arrow up, otherwise the arrow down symbol.

To get that with the right colors is a little tricky, check the following tutorial for that:

Adding Up and Down Arrows to KPIs in Power BI | Tessellation (tessellationtech.io)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hello @Babette ,

did it work eventually with the tutorial I posted?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic