Forum Discussion
how to display a basic line chart ?
Hello Anonymous
The summarization will automatically apply when it comes to "numeric" values (the different Stream columns being defined as numeric). If we want to change that for a specific field we can go to the "Column tools" when a field is selected and set to "don't summarize". I think this is what you did.
In your case, you need to put that Stream1... values on the Y axis; as it's a Y axis, it has to do an aggregation. As you previously set to "do not summarize", power bi will still try to to an aggregation, which will be by default the Count.
This is why you always have 1: it couns the number of values, for each of your date. And thus, for each date, you only have 1 value.
To achieve what you want, you'll need to go back to sum, or min/max (it depends on the case, but for your example min/max could work as well).
To remove that hiererchical part of the date, you need to just click on the "arrow" near your date, and select Date:
(Optional) Depending on the desired result, you may also need to change the X axis to Categorical to have that exact date shown:
If you want to change the format of your shown date, just go to the formatting pane:
You'll obtain smth like that in the end (of course this is a draft that will need to be updated)
Don't hesitate if smth's not clear!
Regards,
Hello Anonymous
The summarization will automatically apply when it comes to "numeric" values (the different Stream columns being defined as numeric). If we want to change that for a specific field we can go to the "Column tools" when a field is selected and set to "don't summarize". I think this is what you did.
In your case, you need to put that Stream1... values on the Y axis; as it's a Y axis, it has to do an aggregation. As you previously set to "do not summarize", power bi will still try to to an aggregation, which will be by default the Count.
This is why you always have 1: it couns the number of values, for each of your date. And thus, for each date, you only have 1 value.
To achieve what you want, you'll need to go back to sum, or min/max (it depends on the case, but for your example min/max could work as well).
To remove that hiererchical part of the date, you need to just click on the "arrow" near your date, and select Date:
(Optional) Depending on the desired result, you may also need to change the X axis to Categorical to have that exact date shown:
If you want to change the format of your shown date, just go to the formatting pane:
You'll obtain smth like that in the end (of course this is a draft that will need to be updated)
Don't hesitate if smth's not clear!
Regards,
Thank you.
I have changed the date and it looks better indeed. "But it shows on my Y axis all the days.
How can I do one (or ideally for my knowledge, the two) following things :
- Bold only the dates where there is a value
- Show only the dates where there is a value
Hello Anonymous
Could you please send a screen capture of your visual? Just to check the "But it shows on my Y axis all the days" part.
Normally Power BI will only show data when you have values. So in your case, if you have 2 dates, it will show 2 dates with corresponding values. We can change that behaviour, and say to Power bI to show items with no data, but not sure if we talk about the same thing
So if you could provide me an example to understand what case do you have it could be great.
Thanks!
Sure, here is the screenshot AnastasiaS :
I have data for only the 25th of January and the 8th of February but all the days in between are displayed (it's actually every 2 days that are displayed) as you can see between my 2 yellow highlights.
I have tried selecting "Show items with no data" but it doesn't change anything on my chart.