Guage Chart visual displays N/A when there is no data

Question & Answer
, , , , ,
1

Hello All,

Facing a issue for Gauge chart visual . Whenever there is no data in dataset for a particular control and filter gauge chart visual should ideally display 0 or no data . But instead it shows N/A which is not feasible.

image
image1416×426 5.13 KB

2

@Rohit_Nikam, curios about your use case, in your use case is numeric measure not populated for any of the data rows, are you trying to compare an actual measure column with target value.

3

Hi @DeepakS ,

Yes we are comparing actual measure column with target value.

4

Hi @DeepakS ,

You can check for below demo dashboard. Go to details page and select date range to current date. and check visual count of tower and volte percentdrop.

https://democentral.learnquicksight.online/#Analysis-DashboardDemo-AnyTel-Insights

NA visual
NA visual1920×1080 165 KB

NA filter
NA filter1920×1080 175 KB

5

Video 3-06 at 13.30 (1)

Hi Check above video for your reference

6

@Rohit_Nikam you can use coalesce function to show zero -
coalesce(Amount,0)

7

Hi @DeepakS ,

Coalesce will work if you have null or blank values but if no data is available then visual should display No data