Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |