Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to show 2 tables, one showing a given quarter data (10s of columns) as per a slicer selection, the other table (same data) the next quarter. Quarter is decided by a date field which is the same field in each case. The only way I could do it so far is to have 2 different slicers (and associate them independently to the different table) which is not ideal for the user to say the least...
I do use a calendar table connected to my dates to keep everything clean (I don't think it matters but just to be thorough).
I tried to think about measures, hidding a filter that would update based on the other one... but I cannot get to a solution.
Thanks,
David
Hi @Anonymous ,
Please try like this:
This Quarter =
VAR Q =
SELECTEDVALUE ( 'Date'[Qtr] )
RETURN
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( 'Table', 'Table'[Qtr] = Q && 'Table'[Year] = MAX ( 'Date'[Year] ) )
)
Next Quarter =
VAR Q =
SELECTEDVALUE ( 'Date'[Qtr] )
RETURN
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( 'Table', 'Table'[Qtr] = Q + 1 && 'Table'[Year] = MAX ( 'Date'[Year] ) )
)
Thanks Xue Ding.
I don't think it will work though.
It's not about the sales value, it is about the individual deals.
I need to be able to filter on Q2 with a slicer and have one table that shows only Q2 deals (bold) and another table that shows only Q3 deals (Italic). I do not want to sum up, I want to show individual lines...
Sample raw data:
Deal | Customer ID | Customer name | Close date | Quarter | Product | quantity | Value |
123 | ABC | Customer1 | 6/20/20 | Q2 | Product A | 1 | 100 |
124 | ABD | Customer2 | 6/15/20 | Q2 | Product B | 2 | 200 |
125 | ABE | Customer3 | 8/12/20 | Q3 | Product C | 3 | 300 |
126 | ABF | Customer4 | 9/13/20 | Q3 | Product D | 4 | 400 |
127 | ABG | Customer5 | 11/9/20 | Q4 | Product E | 5 | 500 |
128 | ABH | Customer6 | 10/3/20 | Q4 | Product F | 6 | 600 |
I don't think a measure is my way out but happy to be proven wrong...
Thanks,
David
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |