topic Re: Power KPI Matrix - Inconsistent Formatting in Custom Visuals Development Discussion

Power KPI Matrix - Inconsistent Formatting

Ameb — Tue, 02 Oct 2018 08:35:29 GMT

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:

Sometimes formatting can't be applied:

Here is the Demo PBIX file

Re: Power KPI Matrix - Inconsistent Formatting

v-viig — Wed, 03 Oct 2018 09:31:14 GMT

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

Re: Power KPI Matrix - Inconsistent Formatting

v-viig — Mon, 04 Feb 2019 13:04:03 GMT

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

Re: Power KPI Matrix - Inconsistent Formatting

Ameb — Wed, 27 Feb 2019 10:00:45 GMT

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

Re: Power KPI Matrix - Inconsistent Formatting

v-evelk — Wed, 27 Feb 2019 12:20:38 GMT

Thanks!

I will check it and provide the status here.

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

Re: Power KPI Matrix - Inconsistent Formatting

v-viig — Mon, 04 Mar 2019 16:31:39 GMT

@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

Re: Power KPI Matrix - Inconsistent Formatting

Ameb — Tue, 05 Mar 2019 09:07:14 GMT

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)

Re: Power KPI Matrix - Inconsistent Formatting

v-viig — Wed, 06 Mar 2019 06:52:48 GMT

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.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Power KPI Matrix - Inconsistent Formatting

suwipach — Wed, 20 Mar 2019 04:10:25 GMT

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.

Re: Power KPI Matrix - Inconsistent Formatting

v-evelk — Wed, 20 Mar 2019 11:46:19 GMT

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

Re: Power KPI Matrix - Inconsistent Formatting

suwipach — Thu, 21 Mar 2019 01:31:55 GMT

i've found the solution by clearing all filter, then arrange the format layout manually in each columns while "Kepp Series Settings On Filtering In Edit Mode" is Off. Thus, column witdth are fixed when i select any slicer.

thank you for reply.

Re: Power KPI Matrix - Inconsistent Formatting

v-evelk — Thu, 21 Mar 2019 13:21:52 GMT

I am glad to hear it.

You are welcome!

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

Re: Power KPI Matrix - Inconsistent Formatting

OskariNi — Tue, 01 Oct 2019 09:51:23 GMT

Hello, I'm experiencing the same issue. Can you please explain if it is possible to keep the formatting constant in some way.

The format and order of metrics changes every time I:

- Add a new KPI to the matrix

- Change the date slicer

- Refresh data

Because of this unpredictable behavior I really can't publish a report with this visual. Otherwise it is an excellent visual.

Thanks, Oskari

Re: Power KPI Matrix - Inconsistent Formatting

v-evelk — Tue, 01 Oct 2019 12:14:23 GMT

Hello Oskari,

Have you tried every recommendation from the topic?

If so, could you please describe case with more details (pictures are preferable too) and share your report by sending to pbicvsupport@microsoft.com ?

Kind Reagards,

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

Re: Power KPI Matrix - Inconsistent Formatting

OskariNi — Mon, 07 Oct 2019 12:14:16 GMT

Hello @v-evelk ,

I can't share my report but here is a few screen captures of the main problem. I changed the formatting of current value column when last 12 months filter was applied. When changing the date filter the formatting resets.

I have tried all the suggested solutions in this thread but none of them work. I would think that the formatting of a visual doesnt depend on the data behind or filtering used. It is quite weird behavior.

BR. Oskari

Re: Power KPI Matrix - Inconsistent Formatting

suwipach — Tue, 08 Oct 2019 01:41:16 GMT

Hello @OskariNi ,

From my experience, i deselected all filters then changed the formatting and saved. Thus, the formatting will be applied with any filters.

Hope this will help.

Best Regards,

Suwipach

Re: Power KPI Matrix - Inconsistent Formatting

OskariNi — Thu, 10 Oct 2019 07:00:42 GMT

Hello @suwipach ,

Thanks for the tip. What do you mean by deselecting all the filters. Did you delete the slicer before doing the formatting?

BR. Oskari

Re: Power KPI Matrix - Inconsistent Formatting

suwipach — Thu, 10 Oct 2019 09:39:23 GMT

Hello @OskariNi

That means None select any filters in slicers. i didn't delete slicers.

BR,

Suwipach

Re: Power KPI Matrix - Inconsistent Formatting

OskariNi — Mon, 14 Oct 2019 09:30:39 GMT

Hello @suwipach ,

This method works if I format "All metrics". Then it remembers the format with all slicer values.

For my report I need to have different formats for each metric. These are reset to the "All metrics" format when I change the slicer value.

Btw. I can't put a None value for my date slicer. The default is the maximum date range of the data.

BR. Oskari

Re: Power KPI Matrix - Inconsistent Formatting

OskariNi — Mon, 14 Oct 2019 09:57:44 GMT

I have tried basically every option that are recommended in this thread, but I'm not able to keep the custom formatting consistent when using a slicer.

It seems that the only option is to do the formatting separately for every slicer value that you think that the user would like to use. At least in my case this makes the visual unusable. It's a shame because the visual is otherwise very good.

Oskari