Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I created a pivot table with sales MTD YOY%, in the dimensions I entered the Year-Month but in the column total the result of the last column is replicated, that is the month of September. On the graph I have inserted the current year as a date filter. Is it possible to see the YTD YOY% value instead of the replicated data? Thank you
Sales Net Amount MTD YoY% | ||||||||||
RM | 2022-01 | 2022-02 | 2022-03 | 2022-04 | 2022-05 | 2022-06 | 2022-07 | 2022-08 | 2022-09 | Total |
A | xx | xx | xx | xx | xx | xx | 3,00% | 2,00% | 3,00% | 3,00% |
B | xx | xx | xx | xx | xx | xx | 1,00% | 1,30% | 4,00% | 4,00% |
C | xx | xx | xx | xx | xx | xx | 1,50% | 1,70% | 1,90% | 1,90% |
Total | xx | xx | xx | xx | xx | xx | 1,83% | 1,67% | 2,97% | 2,97% |
Solved! Go to Solution.
@Morrison , You can use is isfiltered or isinscope to switch the grand total measure
if(isinscope ([Month Year]), [Meausre], [YOY Meausre])
HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@Morrison , You can use is isfiltered or isinscope to switch the grand total measure
if(isinscope ([Month Year]), [Meausre], [YOY Meausre])
HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
User | Count |
---|---|
23 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |