Tile with dynamic dimension data and Metric in Power BI

[akj2784]

Hi,

I have to create a tile with Emp who has Max Opportunties.

And I want to show Emp Name and # of Opportunity in the tile. This is dynamic. So each month whoever has max Opportunties it should be displayed in the tile.

Default tile only accepts Metrics and doesnt allow me to add Emp Name.

Power KPI does not give the tile similar to what we get in default view i.e. center aligned text and metric.

KPI Chart doesnt allow to add Emp Name. Again it accepts metrics

Multi Row card has similar problem.

I want something like below.

[MFelix]

Hi @akj2784,

You need to make a measure and add it to your card but it will not show as you want you can also do two different measures and then add then to two different cards see below both options:

MAX Emp + value=
VAR sss =
    MAX ( Table1[Value] )
RETURN
    CALCULATE (
        MAX ( Table1[Value] ) & " - "
            & MAX ( Table1[  Name] );
        Table1[Value] = sss
    )

MAX Emp =
VAR sss =
    MAX ( Table1[Value] )
RETURN
    CALCULATE (
MAX ( Table1[  Name] );
        Table1[Value] = sss
    )


MAX Value=
    CALCULATE (
        MAX ( Table1[Value] ) )

Regards,

MFelix

[akj2784]

Thank you.. Would you mind sharing the pbix file ?

Also is there any way to do using R or any other Custom visual ?

[MFelix · Accepted solution]

Hi @akj2784,

See atach PBIX file. You can also use the Multi Row card for example (also in the PBIX file) or Using R should be possbile but I don't know how to use R.

Regards,

MFelix