1 of 1 people found this helpful
You mention that you have put the metrics in a single column so that you can use them as a filter. By this, do you mean that you can filter on which measure you would like to see? The reason I'm asking is because there are easier ways to do that that keep your measures separate and therefore easier to format. For example you can use Measure Names as a filter or write a calculation based on a parameter that selects which measure to show. I think both of those options work around the formatting issue.
I'm afraid I cannot currently think of a way to do conditional formatting on the setup you have right now. If I think of something I'll come back to this.
Dana, thanks for the quick help.
Yes, I have done this to have a filter the measure which I would like to see. What other ways can I explore to solve the issue ?
It depends a little on what you have built.
I have certain workbooks where I let people choose the measure to show by using the "measure names" pill on the filters.
I believe you can also keep formatting correct by using a parameter to choose the value to display and using a calculation that simply says case parameter when 'measure 1' then sum(measure1) when 'measure 2' then avg(measure2) etc...
If you set up the Measure Selector as a Parameter (as I would recommend, as there are a few limitations to using the generated 'Measure Names'). The following will probably help
Here I've used a combination of different methods to give custom title and axis formatting for a measure selector. The bits about Axis Headers, and using NULL to expose a '£' on ToolTips (for Sales and Profit Measure) sounds like they'll be useful here.
Let me know if this solves your problem, and if not, I'm sure we can use a combination of these (or derivations of) to get the result you want.
Dana and Simon
Thanks for your suggestions. I will try to implement these tomorrow when get back to work.
Will post in the thread in case I face some issues with the solution.