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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
scottzambonini
New Member

KPI Counter not displaying total when no filters selected

KPI tickerKPI ticker

 

Hi there, 

 

I have a KPI ticker inserted. I cant seem to get the sum total values for goal and spent to date to display as default when dashboard loads, only when I select specific items does it update correctly.
datadata

1 ACCEPTED SOLUTION

Inside the table where the measure uses a column, you can simple add a calculated column with the formula:
IsData = 1

This will add 1 to all the records for that column in that table.

 

In the visual you replace the Trend Axis with this new column and you will get the SUM because you eliminate the Trend Line.

But as I mentioned this might not be the solution you're looking for if you want a trend line 🙂

View solution in original post

3 REPLIES 3
copykai
Resolver I
Resolver I

Hi Scott,

 

The KPI Visual is built to show the latest value only and also the Trend.

A small hack is to add a calculated column where all the values are equal to 1.

If you add this to the Trend Axis you will get the Total SUM but this will remove the Trend Line in the visual.

From my experience you cannot have both in the KPI Visual.

 

Best

Kaj

Sorry to sound daft, can you explain the calculated column?Smiley Happy


@copykai wrote:

Hi Scott,

 

The KPI Visual is built to show the latest value only and also the Trend.

A small hack is to add a calculated column where all the values are equal to 1.

If you add this to the Trend Axis you will get the Total SUM but this will remove the Trend Line in the visual.

From my experience you cannot have both in the KPI Visual.

 

Best

Kaj


 

Inside the table where the measure uses a column, you can simple add a calculated column with the formula:
IsData = 1

This will add 1 to all the records for that column in that table.

 

In the visual you replace the Trend Axis with this new column and you will get the SUM because you eliminate the Trend Line.

But as I mentioned this might not be the solution you're looking for if you want a trend line 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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