Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, Im building a matrix table and I need it to look like the attached image.
I want to add a second header of values below the Year+Week header related to KPIs but I don't know how to build this type of Table.
this are the filelds used.. I tried to order them in different ways but... nothings seems to order them as I need.
Solved! Go to Solution.
Hey @PatCreator ,
you can not achieve what you are looking for without using a little trick.
Create an unrelated table with two columns
Measure Name and Measure Order
Use the name of the measure/columns you are currently using in the Values bucket, and provide an index to order the values of the name column accordingly.
Then you can create a measure like so:
switch measure=
var SelectedKPI = SELECTEDVALUE( 'unrelated table'[NameColumn] )
return
SWITCH(
SelectedKPI
, "name1" , [Measure1]
, "name2" , [Measure3]
, "name3" , [Measure3]
)
Maybe it is necessary that you create measures or internal calculations if the columns you are using in the values bucket are numeric columns and not measures
Hopefully, this provides an idea of how you can tackle your challenge.
Regards,
Tom
Hey @PatCreator ,
please use onedrive, googledrive, or dropbox for the upload, and do not zip the file.
Regards,
Tom
Hey @PatCreator ,
share the link here in this thread.
Regards,
Tom
hi @TomMartens , this is the link with the pbi file zipped thanks for the support https://ln5.sync.com/dl/4c2684fd0/dkugzyvx-c2qe8gs4-vw6k5hb8-w3mk98xm
Hey @PatCreator ,
you can not achieve what you are looking for without using a little trick.
Create an unrelated table with two columns
Measure Name and Measure Order
Use the name of the measure/columns you are currently using in the Values bucket, and provide an index to order the values of the name column accordingly.
Then you can create a measure like so:
switch measure=
var SelectedKPI = SELECTEDVALUE( 'unrelated table'[NameColumn] )
return
SWITCH(
SelectedKPI
, "name1" , [Measure1]
, "name2" , [Measure3]
, "name3" , [Measure3]
)
Maybe it is necessary that you create measures or internal calculations if the columns you are using in the values bucket are numeric columns and not measures
Hopefully, this provides an idea of how you can tackle your challenge.
Regards,
Tom
Hi @TomMartens , Sorry for late response, I've been trying to do what you suggest, but its difficult, I'm still not able to do it right 😞
This is how main data looks like
what I did:
wold it be ok, if I share with you a link to view the pbi rep?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |