Sparkline and data type problum

[Anonymous]

Hello everyone. 

Can someone help me with my problems?

Here is my example data. 

Q1: I want to add a sparkline at the end of each row of this table visual. I know there is a bottom called to add a sparkline, however it doesn't present what I want. 

Q2: As you can see, each column has a different type of number, some of them are the whole number and some are percentages. Is there a way that I can adjust the data type on each row?

Please help 

Thank you so much!

[Anonymous]

Hi @Anonymous ,

//Q1: I want to add a sparkline at the end of each row of this table visual. I know there is a bottom called to add a sparkline, however it doesn't present what I want. 

What is your expected output?

//Q2: As you can see, each column has a different type of number, some of them are the whole number and some are percentages. Is there a way that I can adjust the data type on each row?

Unlike excel, which can set data types for a single cell, Power BI only supports setting data types for columns/fields, and a column/field can only have one data type.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data