Line chart, display one day per week without changing the graph format.

Question

Hello,I have a line chart where the x-axis represents the days. However, I would like to display only one day per week on the x-axis without changing the overall format of the chart. My goal is to show the selected days in yellow, for exemple&nbsp;&nbsp;I attempted to create a calculated column to display only the first day of each week in my line chart, with blank entries for the other days. However, this change affected the overall format of the chart, which I would like to maintain in order to see the evolution over the days:&nbsp;Could you please advise on how to achieve the desired display of only one day per week without altering the format of the chart?

kpost · Answer

When you use "Categorical" mode, every value in the x axis is displayed.&nbsp; When you use "Continuous" mode, Power BI selects which X Axis values to display if there isn't room to display them all.&nbsp; At this time there is no way for the user to create a sort of customized X axis where every value in the chart is displayed but some custom list of X axis values are displayed, for example, "Display every x axis value where the weekday is thursday".
&nbsp;
I even went down a rabbit hole of experimenting with conditional formatting of the X axis value, but apparently there is no filter context in the axis so even if you make an additional calculated column with the weekday and specify that "if weekday = 4, color should be black, otherwise make it white", that doesn't work either.
&nbsp;
If you solve this I'd love to be wrong because there are a few reports I'd modify.
&nbsp;
///Mediocre power bi advice, but it's free///

v-menakakota · Answer

Hi&nbsp;&nbsp;rickferreiran&nbsp;,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.&nbsp;
&nbsp;
Thank you

rickferreiran · Answer

HiI did not find any solution yet.

v-menakakota · Answer

Hi&nbsp;rickferreiran&nbsp;,Thanks for reaching out to the Microsoft fabric community forum.&nbsp;
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.&nbsp;Best Regards,&nbsp;Menaka Kota&nbsp;Community Support Team&nbsp;

v-menakakota · Answer

Hi&nbsp;&nbsp;rickferreiran&nbsp;,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.&nbsp;
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.&nbsp;If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.&nbsp;Thank you for your patience and look forward to hearing from you.&nbsp;

Forum Discussion

Line chart, display one day per week without changing the graph format.

7 Replies

Related content

Change the way a table visualization displays date

Image display in Power bi report

Change numbers to display as thousands or milions

Displaying Change Indicators

Changing which field is displayed in a Matrix or Table