y numeric value should act as text even if they are same

[Jessica_17]

Hello All

I have a calculated coulmn,
example data (not real data):- datetext = format(date,"YYYY MM DD HH" )

suppose I have a date as

date                          datetext              output          val

2023-09-10 11:00    2023091011         11                2

2023-09-10 12:00    2023091012         12                3

2023-09-11 11:00    2023091111         11                3

2023-09-11 12:00    2023091112         12                4

while using output col in y axis of line chart and val in x axis, I am only getting 2 values in y axis , i.e. 11, 12, and the vals are being summed up for 2 different date, I would like that if the date are changing , then the output value should remain as is and the value should sum up only if the date and output are same not else wise. Something like this

I had done one approach, by creating a datetext column and thought of changing the colour of all the value to white except the hour part, but it do not seems to be working.

Please let me know if anyone can help me with this.

[qqqqqwwwweeerrr]

Hi @Jessica_17 

As lbendlin suggests it cannot be possible without a unique value for each data point. that would be the best possible way to do that.

I have tried another way but where you change the datatype for the outcome column and i am not sure is that fessibale, since it might impact other visual or anyother calculation you will performe on that
here i have done some workaround is something similar to that you are looking for?

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards

[Jessica_17]

HI @qqqqqwwwweeerrr 

I only require 11,12 values in x axis instead of 202309... also  being shown in your visual, if that won't be possible , can we make half value of the column in white colour instead of adding any unique points?

[lbendlin]

If you don't want Power BI to aggregate you need to provide unique values for each data point. There's no way around that.

(your expected outcome would also lead to a confusing UX)

[Jessica_17]

HI @lbendlin 
Business wants it in that way, can we make half value of the column in white colour instead of adding any unique points?

[lbendlin]

You could use custom visuals like Deneb, but frankly I would tell Business to reconsider.

[Jessica_17]

Hi @lbendlin 

Thanks for the suggestion, will convince them regarding this.