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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
xevoinx
Regular Visitor

How to create a KPI Bowler?

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. 

 

DescriptionCurrent
Period DisplayJan(2018) - Jun(2018)
Ttl Members Per Period For Client5,000
Total Claims Count15,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 % Claims1.50%
Specialty % Plan Spend50.00%
Generic Dispensing Rate (GDR)82.00%
Rebates$120.00
Plan Cost PMPM with Rebates$60.00
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors