Forum Discussion
Helper IUsing multiple calculation groups at the same time
I have a parameter table that allows me to change the measure currently displayed in the report table. Additionally, I have a calculated group that I can change to show the measure in different contexts like YTD, SPLY, and other options. Is there a way to display the same measure in several different contexts, such as measure 1 YTD and measure 2 YTD, while retaining the table visualization and my parameter table? Something like this:
The problem which I have is that when I use column from param table and put it on table visual I can only select one calculation group item at the same time. I know I could choose matrix visual and put calculation group items on columns but I need to stick to table visual.
thanks!
3 Replies
- amitchandak
Super User
asparagus1_ , I have used multiple in Matrix visual
calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
asparagus1_Thank you for answering. Yes, i know it's possible with matrix but I would like to stick to table visual. I am looking for some workaround or confirmation that is not possible.
- effertz12
Helper II
Hi, so ive watched some of your video and see these formats you are showing:
my question is what if i want to do something like this:
