Forum Discussion
how to display a basic line chart ?
- 3 years ago
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,
Indeed AnastasiaS , setting "Categorical" does the trick for the option "Show only the dates where there is a value", thank you !
Out of curiosity, is it possible to keep "Continuous" and have in bold the dates matching my data (which woiuld cover the other option I was talking about with "Bold only the dates where there is a value") ?
Anonymous I am not sure that we can do that in this way. We could play with the conditional formatting but we wont be able to get the expected result.
If you want to keep the continuous mode, you could maybe use the stacked chart. in this case you'll only see bars for existing values and it will still keep the "blank spaces" between:
So it's not a continuous line as for the line chart:
Idk if this could be helpful.
Regards,