Display Dynamic Column Headers in PowerBI Matrix visual MiTutorials

preview_player
Показать описание
Display Dynamic Column Headers in PowerBI Matrix visual MiTutorials

Рекомендации по теме
Комментарии
Автор

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

TiênLêThịMỹ-ty
Автор

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]



how can I create same your Dax ?

Lee
Автор

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.

MiteshYadav
Автор

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

ashokkumarpadmanabhan
Автор

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

foxysatisfying
Автор

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

meghab
Автор

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

dikshasrivastava
Автор

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()
)

caleboud
Автор

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

KrishnakumarSaini-yg
Автор

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

myplace
Автор

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

yekhtiari