Display Dynamic Column Headers in PowerBI Matrix visual MiTutorials 

Can you add %variance?

Is it also possible to add month to the column so that we can have drill down functionality?

Did you found a way to change the column header name based on the slicer selection?

CAN WE DO SAME FOR MONTH AND IT SHOULD SHOW ONLY CUREEENT MONTH AND LAST MONTH ?

Good Demo !! Brother - Can you share Source file and Power BI File ?

Hello, My dashboard gets updated every day. I am facing some issues implementing last quarter last week data. I need to show QTD, QTR current week , current quarter, previous quarter, and previous week data along with percentage on landing page. For eg. Suppose 2 weeks before it was quarter 1 and work week 13. From today quarter is changing to 2 and work week to 15. Now in previous week data for week 13 it is showing blank values . The problem is I am unable to create measure for last quarter last week data , where I need to show 13th week data, i.e., previous week. NOTE- I have a fiscal year calendar.

Can we extend this to show header for YTD and LYTD with year

instead of using max / min you can just use this var _Years = values(DATES[YEAR]) var _Calc = if( selectedvalue('Year In Use'[YEAR]) in _Years, _SalesQty, blank() )

Suppose if we want month-year like jan- 23. In that how it possible

Blank is showing after creating sales ty and py measure. Why is it so

suppose that my values inside the below measure CY30 SwitchACP = ( SWITCH(TRUE(), SELECTEDVALUE('TCOAP'[SwitchACP])=2,Maher[CY02 SW], SELECTEDVALUE('TCOAP'[SwitchACP])=3,Maher[CY03 Changed], SELECTEDVALUE('TCOAP'[SwitchACP])=4,Maher[CY04 CAL], SELECTEDVALUE('TCOAP'[SwitchACP])=28,Maher[CY28 SWGOPEX], SELECTEDVALUE('TCOAP'[SwitchACP])=25,Maher[CY25 SWNOPEX], SELECTEDVALUE('TCOAP'[SwitchACP])=22,Maher[CY22 SWTOPEX] ))/1000000 how can I create same your Dax ?

Hi admin, Pls help me case Quarter. Exp: selected = Q3/2023 => show data Q3,Q2,Q1/2023. Thanks

Its not working for me