cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ameb Regular Visitor
Regular Visitor

Power KPI Matrix - Inconsistent Formatting

Hello

 

Formatting options for Power KPI Matrix are buggy and inconsistent, making impossible to combine differently formatted data.

I guess this is related to Power KPI Matrix - Losing Format after Refresh - Row Based

 

This is expected behavior if you change data rows because Power KPI Matrix binds settings to data rows.
There're a few technical limitations that prevent us from fixing it.

 

When you change filters formatting is lost. It is tied to data rows as stated on the link above:

 

filters.gif

 

 

Sometimes formatting can't be applied:

 

test.gif

 

Here is the Demo PBIX file

11 REPLIES 11
Moderator v-viig
Moderator

Re: Power KPI Matrix - Inconsistent Formatting

This is expected limitation that is documented in the sample report of Power KPI Matrix.

 

We'll investigate possible solutions soon based on priority.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Moderator v-viig
Moderator

Re: Power KPI Matrix - Inconsistent Formatting

This issue has been fixed in the latest version of Power KPI Matrix. Please open a report and turn on and turn off “As of Date” option.

After that you should save a report.

 

These steps save settings into special storage that supports up to 20 rows. So, 20 rows won’t lose settings on filtering.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Ameb Regular Visitor
Regular Visitor

Re: Power KPI Matrix - Inconsistent Formatting

The Sometimes formatting can't be applied issue is not resolved. 

v-evelk Senior Member
Senior Member

Re: Power KPI Matrix - Inconsistent Formatting

Thanks!

I will check it and provide the status here.

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Moderator v-viig
Moderator

Re: Power KPI Matrix - Inconsistent Formatting

@Ameb Can you share a report that we can use to reproduce that?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Ameb Regular Visitor
Regular Visitor

Re: Power KPI Matrix - Inconsistent Formatting

It seems that i didn't tested it properly and after saving and reopening the file i could set the formatting without many problems.

 

 

The way it works is that you have to manually set the formatting for each combination of filters, and it will store the last 20 combinations? On the following gif i have set formatting (Current Value) for No filtering and for year 2018. Ignore the empty KPI Status (no data)

powerKPI.gif

 

Moderator v-viig
Moderator

Re: Power KPI Matrix - Inconsistent Formatting

Are you testing in Power BI Desktop?

 

PBI Desktop is for editing only. That means Power KPI Matrix uses current filter + settings set.

If you want to persist settings in Edit mode you should enable Format Panel -> Table -> Keep Series Settings On Filtering In Edit Mode.

 

If this option is enabled you won't be able to change settings.

 

image.png

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Highlighted
suwipach Frequent Visitor
Frequent Visitor

Re: Power KPI Matrix - Inconsistent Formatting

How could i save format setting set for that 20 combination filters in column based table ?

if i have 2 slicers: one is to swith between current month data and year-to-date data, second is to swith between country.

Then, power KPI Matrix shows KPI by company of country selected and current month or ytd selected, which number of company in each countries does not equal. column layout will get back to default when i swith slicer selected and it's small that i cant see amount inside.

v-evelk Senior Member
Senior Member

Re: Power KPI Matrix - Inconsistent Formatting

Hello,

 

Have you enabled the option "Kepp Series Settings On Filtering In Edit Mode"?

Could you please clarify your issue, provide screenshots?

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 47 members 1,192 guests
Please welcome our newest community members: