Tabular view with NHS Icons

[moranm1]

Please would it be possible to include the ability to display data in a tabular view with the variation and assurance icons as per the example below? This is the recommended approach across Integrated Performance Reports for a lot of NHS Trusts.

[carolineb936]

Yes Please would love this

[LeslieHewitt]

This is in the https://future.nhs.uk/MDC/view?objectId=118528357 Power BI Template on the FutureNHS website.

[andrjohns]

A summary table with icons is now implemented (see guide here for more details)

[moranm1]

Hi thank you for implementing this, which version of the tool is it available in? The version on the Microsoft store is 1.4.1.4, I've downloaded it and I cant see the Grouping (summary table) field. Thanks

[andrjohns]

It's currently only available in the development version of the visual (installation instructions here)

We're currently completing a round of testing and gathering feedback on the implementation, before submitting to Microsoft in a month or two (depending on feedback)

[carolineb936]

I have imported and tried this with my date and get an error when trying to add the NHS icons

[carolineb936]

[moranm1]

I got the same error you have to make sure you have turned on the Outlier Detection settings

[andrjohns]

I have imported and tried this with my date and get an error when trying to add the NHS icons

Yes, as the error message indicates, the Variation icon is meaningless if you haven't enabled the detection of any outlier patterns.

The Variation icon is used to indicate the presence of special-cause or common-cause variation, where special-cause variation is determined by the presence of an outlier pattern (astronomical point, shift, trend, etc.). If you haven't enabled the detection of any outlier patterns (i.e., the detection of special-cause variation), then the variation icon will always show common cause

[carolineb936]

Is there a limit to the number of rows showing - I can only see 10 - not sure if I can show more

[andrjohns]

Is there a limit to the number of rows showing - I can only see 10 - not sure if I can show more

How many rows of data are you passing to the visual? PowerBI has a hard limit of 30 000 rows for custom visuals

There's an API to add support for fetching additional rows, but it requires some additional complexity in data management and fetching/appending updates, so I don't think I'll be able to add it for the next release

[carolineb936]

It is only a few more rows I was after (eg 20) But I will filter them into groups of 10 and show 2 tables instead, until an update comes through

[andrjohns]

It is only a few more rows I was after (eg 20) But I will filter them into groups of 10 and show 2 tables instead, until an update comes through

Just to clarify - it's not about the number of rows displayed in the table (10 vs 20), but the amount of data being passed to the visual (e.g., the length of the numerator column) - so you might still receive the same warning when filtering to groups of 10 if the resulting data exceeds 30 000 rows

[carolineb936]

Sorry If I am being a bit dense but if I filter on top 10 and bottom 10 it works OK and the underlying data rows are the same