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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

Top Solution Authors
Top Kudoed Authors