Hi Anjal, I think we need to see how your data is structured.

But if it is as simple as something like this, then you can create a dimension swapper.  The table just shows the structure of the data. And I have created a parameter and formula linked to it showing in the screenshot.

Now we can remove all the Report A, B, C, D dimensions, and just put the calculated Report Dimension here. When we select a report from the parameter, our table will give us that report's numbers:

If this doesn't help, send a sample of data .

Best,

Jennifer

The second screenshot doesn't show what you want? Is it that you don't want the parameter?

Thanks,

Jennifer

Oh of course. .twbx Attached.

For Choose Report, manually create a Parameter:

And type the List of values in:

Sure thing, happy to help.

Hmm, I think some sort of bar chart would be good, there are a few options in the workbook I attached (I used Report D as an example and created some negative numbers).  If you have questions on any of them let me know.

Best,

Jennifer

Sure. I have three types, all pretty simple. I'll screenshot the whole view so you can which fields go where.

Vertical Bar, no special color, compares a second dimension (months in this case) within each Report value.

Horizontal Bars, Colored by volume, compares each Report value within a second dimension.

Stacked Horizontal Bar (not sure this is the best option for comparing 0-30, 31-60, etc. across multiple dimensions, but it's kind of nice to see the span of values all in one bar, and gives a quick sense of total negative vs positive values among the whole)

If you click on the legend, you can highlight a value to more easily see its trend:

If you need further detail, let me know.

Best,

Jennifer