undefined

[Anonymous]

i have on my x axis year and month and its tool tip is also showing same. how can i make tooltip to show only month in the tooltip and not year and month both  in powerbi

[Anonymous]

@bhanu_gautam Thanks for the solution.

[Anonymous]

Hi @bhanu_gautam thanks for the quick response.May be i didn't mentioned my problem clearly.So here is the whole situation: I am a line and cluster column chart .while adding data to the visual on the Xaxis i added Year and Month (both are different columns in my table) .Now while hovering on the bars of the graph it is showing 2023 2023M11 , i only want it to show 2023M11.I hope the example makes easier to understand my problem.

[Anonymous]

Hi,

Thanks for the solution bhanu_gautam  offered and i want to offer some more information for user to refer to.

hello @Anonymous , based on your description, you can use report tooltip, you can create a new page, select 'Allow  use as a tooltip' in page information. and select'Tooltip' type in Canvas settings.

then just put the month column and value column to a visual in new page(such as table visual).

Then in the line and cluster column chart,select the report page tooltip.

Output

And you can refer to the following link about it.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhanu_gautam · Accepted solution]

@Anonymous ,reate a new column for the month:
Go to the "Data" view in Power BI.
Select the table that contains your date column.
Create a new column by clicking on "New Column" in the "Modeling" tab.
Use the following DAX formula to extract the month name:
DAX
MonthName = FORMAT([YourDateColumn], "MMMM")
Replace [YourDateColumn] with the name of your date column.
Modify the tooltip:
Go to the "Report" view.
Select the visual where you want to customize the tooltip.
In the "Visualizations" pane, click on the "Format" (paint roller) icon.
Expand the "Tooltip" section.
Add the newly created MonthName column to the "Tooltip" field well.
Remove any other fields that you do not want to appear in the tooltip.
By following these steps, the tooltip will display only the month name instead of both the year and month