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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AnFroyman
Frequent Visitor

Change in visual after connecting to shared dataset

I wanted to 'split' 1 report in different ones.

 

What I did:

- I saved my original report as a new report .pbix file

- I deleted the sheets I did not want anymore in the new report.

- I deleted all tables in the new report (in the data model section)

- I connected again to the already published dataset from the original report.

 

Then, the visual in the attached screenshot changes (the original report to the left, with the correct visual, the new report to the right). What can be causing this?

It looks like there is something going on with the date (format) (in the measure shown?)

 

2023-08-24_11h39_29.png

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @AnFroyman ,

 

so the difference is that one of them is on the year level and the second is drilled down to the month level.

Idrissshatila_0-1692872178012.png

 

the first one that you have years you click on this icon so it would be like the second one

Idrissshatila_1-1692872227729.png

 

 

while if you want the second to show only year you click on this icon 

Idrissshatila_2-1692872271798.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @AnFroyman ,

 

so the difference is that one of them is on the year level and the second is drilled down to the month level.

Idrissshatila_0-1692872178012.png

 

the first one that you have years you click on this icon so it would be like the second one

Idrissshatila_1-1692872227729.png

 

 

while if you want the second to show only year you click on this icon 

Idrissshatila_2-1692872271798.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors