Forum Discussion
Date Measure
piuh , okay. But no worries I fully understand that you can not share the data, but at least a get a big picture. 🙂
I mean I know you want to show data but still you do a calculation right. For the red table you takr for example the sum or max of a column for a specific month. and for the blue tables you take the sum over several months. Something like this would be possible with the appraoch I described.
Can you build an easy example with dummy data? I mean it can be a few rows manually typed in Excel.
- 1 date table (this I know how it looks like) 😉
- 1 red table example
- 1 blue table example
- and an example what you want to Calculate/vizualize
It only has to be a few rows per table
Best regards
Michael
Mikelytics Ok I put together some test data as a proof of concept. This is a screenshot of what I want to get:
AS a note of reference, this table has two slicers that are only interacting with the visual that is in the same box, but in my actual project, I would like there to only be one slider like the one that selects a month name. As you can see, the "blue table" will show all metrics with dates between the beginning of the year and the end of the month name that is selected, while the "red table" will only show data for a singular selected month.
Unfortunately my organization does not allow for sharing of any files, as the file share is not an option for me to select.