Forum Discussion
Responsive ResidentScorecard Creation
Hi KarenFingerhut ,
Glad to know that you've nailed it.
Please kindly mark the helpful suggestion as solution to help others find it more quickly. thanks!
Responsive ResidentHi Greg
Thanks for getting back to me so promptly.
So basically he'll have to change the format i.e. put it in a table or matrix? If he decides no drilldown is necesasry can you please advise me on the best visual for this. Or isnt there one that can do it
Mnay thanks and regards
Karen
Community SupportHi KarenFingerhut ,
If no drilldown is nessary, I think both table/Matrix works fine. you can refer to below post to set the confitional formatting:
- KarenFingerhut
Hi Dina
Thanks for getting back to me.
Its definitely something I can use in the future but sadly not quite what im looking for now. I've have managed to get the layout how I want it but I did something in the editing section and for the life of me cannot remember how I did it. Here's what I did from my main query. I managed to split each component in to a table. It actually works really well for what I need but my mind gone blank as to how I did it !!!
Kind regards
Karen
- v-diye-msft
Hi KarenFingerhut ,
It seems you used group and then expand the table, details have been recorded in your right "APPLIED STEPS" pane, and you can output the table with the hierachy and drilldown it in visuals, but it's not accessible to set the conditional format in query editor. based on your description , if data is greater than the previous one, show it in "Red". measure is required to achieve this.
- KarenFingerhut
Hi Dina
Many thanks for the informatiion and apologies for the late reply.
I've now managed to create the scorecard based on all the advice. All still allearning curve but definitely getting there.
Once again thank you
Kind regards
Karen