Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 🙂
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?
@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 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |