Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
Im new in Power BI and im wondering things for this vusualization
- How to include a table who summarize the number of transaction for each year next to my visualization ?
- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.
Thank you !
Solved! Go to Solution.
Hi @AudreyRene ,
Please see my answers below:
- How to include a table who summarize the number of transaction for each year next to my visualization ?
- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.
See the example below:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsWelcome to Power BI! Let's address your queries one by one:
1. Including a Summary Table Next to Your Visualization:
- To create a summary table, you can use a "Table" or "Matrix" visual in Power BI.
- First, create a measure or use an existing one that sums the number of transactions per year.
- Then, add a new visual to your report canvas, and in the Fields pane, drag your 'Date' field into the "Rows" area and your transaction measure into the "Values" area.
- In the visualizations pane, format the table to only display the year part of your 'Date' field.
- Position this new table visual next to your line chart on the canvas for a side-by-side view.
2. Missing Months in the Line Chart:
- Power BI may show every other month on the axis to avoid cluttering, especially when there isn't enough space to display all labels.
- To fix this, you can adjust the x-axis properties:
- Click on the line chart visual.
- Go to the "Format" pane (the paintbrush icon).
- Scroll down to the "X-Axis" settings.
- Look for the "Type" property – if it's set to "Categorical", try changing it to "Continuous".
- Also, check the "Label density" slider to increase or decrease the number of labels shown.
- Make sure that the "Show" option for labels is turned on, and you may also adjust the text size to fit more labels if needed.
By adjusting these settings, you can include all months on the x-axis and display a summary table alongside your visual, offering a comprehensive view of the transaction data. If you still encounter issues with missing months, it may also be worth checking your data to ensure all months are present and properly formatted.
Hello,
Everything works ! Thanks to all of you 🙂
Hi @AudreyRene ,
Please see my answers below:
- How to include a table who summarize the number of transaction for each year next to my visualization ?
- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.
See the example below:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello,
- How to include a table who summarize the number of transaction for each year next to my visualization ?
- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
59 | |
58 |