Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a calculated column (Day Rate) and I'm trying to show that against the month in a matrix.
I want to add a title to the row on the left to show end users that this is the day rate. Is that possible?
Solved! Go to Solution.
Hi @MissBI_21 ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Table 2 =
var _summtable=
SUMMARIZE('Mian Table',
'Mian Table'[Date],
"Group","Day Rate",
"Value",
DIVIDE(
SUMX(ALL('Mian Table'),[Amount]),
SUMX(FILTER(ALL('Mian Table'),MONTH('Mian Table'[Date])=MONTH(EARLIER('Mian Table'[Date]))&&'Mian Table'[Group]=[Group]),[Amount])
))
return
UNION(
'Mian Table',_summtable)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @MissBI_21 ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Table 2 =
var _summtable=
SUMMARIZE('Mian Table',
'Mian Table'[Date],
"Group","Day Rate",
"Value",
DIVIDE(
SUMX(ALL('Mian Table'),[Amount]),
SUMX(FILTER(ALL('Mian Table'),MONTH('Mian Table'[Date])=MONTH(EARLIER('Mian Table'[Date]))&&'Mian Table'[Group]=[Group]),[Amount])
))
return
UNION(
'Mian Table',_summtable)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Else can create a text box near the row, or even create tooltip page which can appear just by hovering over the visual.
@MissBI_21 , You can use Matrix Title under property, if that can serve purpose
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.