The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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.
Hey mate,
Thanks for responding. I'm actually required to show the metrics in a tabular form. Any ideas how I can do that?