Forum Discussion

sure19's avatar
sure19
Helper II
4 years ago
Solved

visual table heading

Hello All,  is there any way to create headings as below?  Figure 1 is the manually done report.  Figure 2 is the power bi report.  I wanted to design the headings as the manual report.
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi sure19 ,

     

    If all values in matrix value field are measures, as my above reply, we couldn't add measure into matrix column. In Power BI, we couldn't catch column header or measure header directly. Here I suggest you to create a hierachy level with measure name manually.

    Then create a measure with all measures you create before.

    Measure = 
VAR _AssetHealth2021YTD = 1
VAR _AssetHealthTarget = 2
VAR _CBMCoverage2021YTD = 3
VAR _CBMCoverageTarget = 4
RETURN
IF(
MAX('Table'[Level2]) ="2021 YTD",
switch(MAX('Table'[Level1]),"% Asset Health",_AssetHealth2021YTD,"%CBM Coverage",_CBMCoverage2021YTD,BLANK()),
switch(MAX('Table'[Level1]),"% Asset Health",_CBMCoverage2021YTD,"%CBM Coverage",_CBMCoverageTarget,BLANK())
)

    Don't forget to relate your measures with QC (matrix row) to get correct result.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sure19's avatar
sure19
Helper II
4 years ago

Thanks for the reply Rico, but my data is a calculated measure so as per you, this cannot be used in that case?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi sure19 ,

 

If all values in matrix value field are measures, as my above reply, we couldn't add measure into matrix column. In Power BI, we couldn't catch column header or measure header directly. Here I suggest you to create a hierachy level with measure name manually.

Then create a measure with all measures you create before.

Measure = 
VAR _AssetHealth2021YTD = 1
VAR _AssetHealthTarget = 2
VAR _CBMCoverage2021YTD = 3
VAR _CBMCoverageTarget = 4
RETURN
IF(
MAX('Table'[Level2]) ="2021 YTD",
switch(MAX('Table'[Level1]),"% Asset Health",_AssetHealth2021YTD,"%CBM Coverage",_CBMCoverage2021YTD,BLANK()),
switch(MAX('Table'[Level1]),"% Asset Health",_CBMCoverage2021YTD,"%CBM Coverage",_CBMCoverageTarget,BLANK())
)

Don't forget to relate your measures with QC (matrix row) to get correct result.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.