Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

undefined

in the bar chart, there is growth percentage for 2024 and 2025 , so how we are calculated , suppose in 2024 we hve 22119 an din 2025 we have 25644, approx we have 15% of growth we have so like as in ...
Interesting Links
Need Help
Tips and Tricks
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    8 months ago

    Hi Anonymous ,

    If a drillthrough button doesn't navigate to the target page, follow these suggestions:

    1. Verify that the button’s Action is set to Drillthrough.
    2. Verify that the Drillthrough target is correctly selected.
    3. Make sure the report is published and the button isn't disabled due to missing filter context.

     

     

    If the drillthrough page opens but doesn't filter as expected, follow these suggestions:

    1. Check that the field used for drillthrough isn't duplicated or transformed in Power Query.
    2. Check for relationships between tables that can affect filter propagation.
    3. Use the Performance analyzer to inspect query behavior and confirm filter application.

     

    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

amitchandak's avatar
amitchandak
Super User
8 months ago

Anonymous , we can use isinscope to switch mom vs QOQ vs YOY 

 

Assuming we already have measure of we can use offset for that. Start with leaf level  

Switch(true(),
isinscope(Date[Month Year]) , [MOM %],
isinscope(Date[Qtr Year]) , [QOQ%],

[YOY %]
)

 

Offset example 

Last period= SWITCH(TRUE(),
 ISINSCOPE('Date'[Month Year]), CALCULATE([Net], OFFSET(-1,ALLSELECTED('Date'[Month Year], 'Date'[Month Year Sort],'Date'[Qtr],'Date'[Year]),ORDERBY('Date'[Month Year Sort]))),
 ISINSCOPE('Date'[Qtr]), CALCULATE([Net], OFFSET(-1,ALLSELECTED('Date'[Qtr],'Date'[Year]),ORDERBY('Date'[Qtr]))),
 CALCULATE([Net], OFFSET(-1,ALLSELECTED('Date'[Year]),ORDERBY('Date'[Year])))
)



How to use offset for that 
Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

Using TI for that 
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA