Forum Discussion

Throgan's avatar
Throgan
Frequent Visitor
3 years ago

Card Visual showing Zero but correct in Desktop

I have a Card visual that shows correctly in Desktop but shows zero in the Service.   I verified that the DAX works in desktop, there is data in the table, and I refreshed the data in the workspace...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

In the service, can you Edit the report and open a new page where you can add a Card and the measure please?

Throgan's avatar
Throgan
Frequent Visitor
3 years ago

I created a new page and created a card visual. Added that measure.

No change


 

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Please delete the FILTER fucntion from the measure

    • Throgan's avatar
      Throgan
      Frequent Visitor
      3 years ago

      I found the issue. 

      The service wasn't picking up the change on the column from True/False to Text.

      In Transform Data, I switched that column from Text to True/False and then back to Text.

       

      When I saved and refreshed, the service had the correct data in the visual.

       

      Thank you for your help. 🙂