cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NKotak_Leecare
Helper III
Helper III

Not able to Add 'id' field to a card visual

I am trying to add Id field in fields value for a card visualisation. However, I am not able to add it for some reason. I tried changing the data types of id field. I have kept it as 'Whole Number'. But it contains null value. I am not sure if that is the reason I can't add it in the card visual. So, I replaced null with '0' value but i am still not able to add the Id field to a card visual.

 

The same thing is happening when I try to add Id in x-axis or y-axis. It won't let me add Id to any of the axis.

 

Any tips or suggestion would be highly appreciated.

 

Cheers,

Nidhi

5 REPLIES 5
Arul
Super User
Super User

@NKotak_Leecare ,

how you want show Id in card field needs to be considered here. So can you share screenshot of actual and expected output?

Thanks,

Arul

Regards,
Arul
If I answered your question kindly mark my post as a solution and a kudo would be appreciated.

@Arul Thank you for your response.

 

I would like to have the count of Id in the card. So below is the snapshot of it working previously and the error that is throwing right now.

 

bedpk card.pngerror card.png

 

Thank you for your help in advance.

 

Cheers!

@NKotak_Leecare ,

It seems you have changed your column name in underlying dataset. Please check it once if not close power bi and re-open it sometimes it works due to some bug....

Thanks,

Arul

Regards,
Arul
If I answered your question kindly mark my post as a solution and a kudo would be appreciated.

@Arul 

 

I have tried that but the name is not the issue. As i took a new card visual and tried to add the Id field in it but it won't let me. However, if I take a table visual and add the ID it lets me do that. Once I display it using table visual, I changed the visual to card and it worked. I still don't understand why it won't accept 'Id' field in card like before.

 

Thanks so much for your suggestions.

@NKotak_Leecare ,

If you can share sample data that would be great to see the issue and help.

Thanks,

Arul

Regards,
Arul
If I answered your question kindly mark my post as a solution and a kudo would be appreciated.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors