Need Percentage in Column but showing in Row in Power BI Matrix Visualization

[mohittimpus]

Hello All,

I Need Percentage in Column but showing in Row in matrix visualization as showing in below image :

One more required example below like:

Please find attaached .PBIX file below:

https://drive.google.com/file/d/1hsjPgX2mU6Jx4oxaZ0fUerIOkXhAv0-g/view?usp=sharing 

[v-yalanwu-msft · Accepted solution]

Hi @mohittimpus  ,

According to your description, you could create a measure by the following formula：

percentage =
VAR _count =
    CALCULATE (
        COUNT ( Recertification[CERTIFICATION] ),
        ALLEXCEPT ( Recertification, Recertification[Executive Approval] )
    )
VAR _total =
    IF (
        HASONEVALUE ( Recertification[SYSTEMNAME] ),
        COUNT ( Recertification[CERTIFICATION] ),
        FORMAT ( DIVIDE ( _count, COUNTROWS ( ALL ( Recertification ) ) ), "Percent" )
    )
RETURN
    IF (
        ISINSCOPE ( Recertification[Executive Approval] ),
        _total,
        FORMAT ( 1, "Percent" )
    )

Then put this measure in "Values" field:

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

[amitchandak]

@mohittimpus , seem like you are looking for a hybrid column

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc