Forum Discussion

sridevi's avatar
sridevi
Icon for Helper I rankHelper I
9 years ago

Hide the data values or show blanks from Card visuals while not filtering data from slicer

Hi,   I need some help from you all. I need to hide my data from Card Visual chart in Power BI at initially in dashboard. I used some slicers for filters in my report. I want to show my card visual...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi sridevi,

 

To solve the issue that the Card Visual shows the number format as wrongly(220,00 instead of 220), please control the data format in DAX query:

 

= IF(HASONEVALUE('KTOC DATA'[TYP_PRODUCT_RELEASE]);FORMAT(DISTINCTCOUNT('KTOC DATA'[ProductGUID]), “###.##”; ””)

 

If you have any question, please feel free to ask.

 

Best regards,
Yuliana Gu

sridevi's avatar
sridevi
Icon for Helper I rankHelper I
9 years ago

Hi v-yulgu-msft,

 

I tried to implement the same as my own measurement.  Please see this below measurement.

 

No. of units for product release = IF(HASONEVALUE('KTOC DATA'[TYP_PRODUCT_RELEASE]);FORMAT(DISTINCTCOUNT('KTOC DATA'[ProductGUID]);"###");"")

 

But I got the below error.

 

 

It seems conversion error text to number.

 

My expected output would be that No.product units should be displayed as whole number ex: 2340 if I filtered something from  my slicer and If i dont apply filter then my output would be none(empty). I dont want to display as 0.

 

As of now I currently used below formula as displayed 0 without applying any format.

No. of units for product release = IF(HASONEVALUE('KTOC DATA'[TYP_PRODUCT_RELEASE]);DISTINCTCOUNT('KTOC DATA'[ProductGUID]);0)

 

Could you please help me how to resolve my error while applying format in my formula.

 

Thanks in advance.

 

Regards

Sridevi