Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
akj2784
Post Partisan
Post Partisan

Tile with dynamic dimension data and Metric in Power BI

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.Tile.JPG

 

 

 

1 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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

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] ) )

measure.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

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

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.