How to create a KPI Bowler?

[xevoinx]

Hello, 

I am trying to create something like this in Power BI, but unable to do so. Is it possible to create a KPI Bowler or list the descriptions as such: 

I need to have dates show as columns and the descriptions as rows. 

Description	Current
Period Display	Jan(2018) - Jun(2018)
Ttl Members Per Period For Client	5,000
Total Claims Count	15,000
Total Gross Cost	$3,102,050.00
Total Plan Cost	$2,860,000.00
Total Plan Cost PMPM	$80.00
Member Cost Share	$220,000.00
Specialty Plan Spend	$1,400,000.00
Specialty % Claims	1.50%
Specialty % Plan Spend	50.00%
Generic Dispensing Rate (GDR)	82.00%
Rebates	$120.00
Plan Cost PMPM with Rebates	$60.00

[v-shex-msft · Accepted solution]

Hi @xevoinx,

I think matrix visual will suitable for your requirement, it support to summary amount based category column and expand date range on column fields.

Use the Matrix visual in Power BI Desktop

After these steps, you can use conditional formatting on value field to show different colors to achieve kpi effect.

Conditional formatting in tables

Regards,

Xiaoxin Sheng