Dynamic KPI table with different metrics

[CCAd]

Hi all,

I am trying to move from a tile based dashboard to a table visual to report on various KPIs. I already have measures for each of these metrics in a measures table. What I want to do is have the following in each column: metrics/KPIs, targets, actuals, actuals SPLY, average/sum running to date etc. Each of the measures for these metrics draw their data from their own distinct tables which have relationships in place.

My table looks like this:

Target	Measurables	Actuals
10	Submissions / Proposals	0
25%	Appraisal to List	19.4%
30	New Listings
135	Current Listings
80%	List to sell/Lease Rate	0%
450	Enquiries
30	Deals Registered
30	Deals Settled
$100,000.00	VPA Received
160	F2F Meetings
10	Management Proposals
8	New Managements
35%	% Market Share

I just cannot figure out how to go about it. Any help will be highly appreciated.

Thanks

[v-stephen-msft]

Hi @CCAd ,

You can try the custom visual called Multi KPI.

MULTI KPI custom visual in Power BI - Power BI Docs

Best Regards,

Stephen Tao

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

[CCAd]

Hey mate,

Thanks for responding. I'm actually required to show the metrics in a tabular form. Any ideas how I can do that?