Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
AudreyRene
Helper I
Helper I

Modify Visualization

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.

 

AudreyRene_1-1712935860363.png

 

Thank you !

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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 ?

  • Create a Matrix visualization with the year has column, and the sales has values this will give you the result you need

- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.

  • The months are not missing this is an option on the x-axis since you are using a date column it does a continuous axis, if you want to show all the months then you need to change from a date column to a Year /month column that you need to add to your model

See the example below:

 

MFelix_0-1712942348980.pngMFelix_1-1712942509090.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
AnalyticsWizard
Super User
Super User

Welcome 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 🙂

MFelix
Super User
Super User

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 ?

  • Create a Matrix visualization with the year has column, and the sales has values this will give you the result you need

- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.

  • The months are not missing this is an option on the x-axis since you are using a date column it does a continuous axis, if you want to show all the months then you need to change from a date column to a Year /month column that you need to add to your model

See the example below:

 

MFelix_0-1712942348980.pngMFelix_1-1712942509090.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hello,

 

- How to include a table who summarize the number of transaction for each year next to my visualization ?

  • I don't see how to choose the year only has column

AudreyRene_0-1712945021374.png

 

- Why some month are missing (january, april, june etc.). It seems like Power BI goes by every 2 month.

  • Thanks i didn't know ! 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.