Hi,
I have this bar chart visual and one of the bars for May is not showing the label (the rest ok) for some reason even that I can see that there is data on that particular month.
Hence, I tried to create a new column in the relevant table to see if it may come up for May for which I used just the same function/table.
Yet, not only still no labels in that specific bar for May, but also it's counting everything not just distinct values. I know that because i changed the function to COUNT and sure enough all the records are coming up same as the New Column output results.
I am a bit puzzled and can't possibly see what I am doing wrong here. I understand you may don't quite know the reason. Thank you in advance
Letters Sent.Measure = DISTINCTCOUNTNOBLANK('Letters''[CommunicationID])
Letters Sent.New Column = DISTINCTCOUNTNOBLANK('Letters''[CommunicationID])
I have this bar chart visual and one of the bars for May is not showing the label (the rest ok) for some reason even that I can see that there is data on that particular month.
Hence, I tried to create a new column in the relevant table to see if it may come up for May for which I used just the same function/table.
Yet, not only still no labels in that specific bar for May, but also it's counting everything not just distinct values. I know that because i changed the function to COUNT and sure enough all the records are coming up same as the New Column output results.
I am a bit puzzled and can't possibly see what I am doing wrong here. I understand you may don't quite know the reason. Thank you in advance
Letters Sent.Measure = DISTINCTCOUNTNOBLANK('Letters''[CommunicationID])
Letters Sent.New Column = DISTINCTCOUNTNOBLANK('Letters''[CommunicationID])