cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Can`t move WHOLE number column to Values position in visualization

Hello, guys! 

Had added some data to report and got a problem.

 

I have a whole number format column. But cant use it as Value in chart! 

Just cant move it into Values place!!!

 

two.PNG

 

 

one.PNG

 

Whats wrong ? 

Many thanks

 

 

3 REPLIES 3
Chrisjr
Helper IV
Helper IV

Hi @Anonymous I am havig the same issues. Have you managed to solve your problem.?
Also, in a matrix, I am not able to slide a dim into the value and use it as first vale. 

 

In my modeling, the column has the summariszation icon. But on the front-end, it does not have the summarization icon.

Anonymous
Not applicable

Moreover, there is no such icon (summarization) near the column!

not.PNG

Hi @Anonymous ,

 

What is the connection mode? If it is import mode, try to change the data format to whole number in the query editor.

Or you could refer to this thread:

https://github.com/otykier/TabularEditor/issues/544 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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