Forum Discussion
sure19
4 years agoHelper II
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.
- Anonymous4 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sure19
4 years agoHelper II
Hi Amit, I could not get the related topic using the links you shared.