Forum Discussion

phelms2's avatar
phelms2
Regular Visitor
1 year ago

Reference labels on New Card Visual autoformat numbers (column type: Text) - no way to change it?!

I have a New Card Visual where I need to provide a year for reference. Since some of the years are with text (i.e. FY2025), the column has "Text" as datatype. Now, when I insert the year in a refe...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
1 year ago

phelms2 , Based on what I got.  Once you select a series after adding label, you should be able to change format under values

 

Display unit

 

 

phelms2's avatar
phelms2
Regular Visitor
1 year ago

amitchandak 

Actually, the issue is that the column format is "Text" - so I cannot change the format by default. 

My "solution" was to change the column format in Power Query from "Text" to "Whole Number", load the data (with errors) into Power BI, change the format number on the reference label from "Auto" to "None" -> then go back to Power Query and delete the last format change and reload data into Power BI.

That solved my issue, but if the model is not in import mode, I could not do this hack. How do we get the developers attention towards this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi phelms2,

    Glad to know you were able to solve your issue. Also if you want to raise any points or issue towards developers I suggest Ideas forum. Here you can raise an idea or upvote for a pending idea. Go through the below link for Ideas Forum.
    Ideas Forum 

     

    Best Regards,

    Hammad.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi phelms2,

      As we haven’t heard back from you, so just following up to our previous message. As the issue has been resolved, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
      If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
      Thank you for your patience and look forward to hearing from you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi phelms2,

        We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

        If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

        Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

         

        Thank you for your understanding and participation.