cancel
Showing results for 
Search instead for 
Did you mean: 

Bookmarks not saving all drill mode drill down filters

When creating a bookmark or comment, drill mode selections are only saved if every layer was drilled using drill mode. I would expect all drill filters to be save regardless of whether all layers had a drill filter applied. Here is a generic example of when the bug occurs vs when the bookmark saves properly:

Not Working Bookmark Example:

Visual A has 4 levels of drill down available (Level 1, Level 2, ...). Each Level has 4 categories (A, B, C, D). At Level 1, I use drill mode to drill into Category 1-A. In Level 2, I use "Drill to next level in Heirarchy" to go to Level 3. In Level 3, I use drill mode to drill into Category 3-D and am now at Level 4, with drill filters applied for Level 1's Category 1-A and Level 3's Category 3-D. I save a personal bookmark at this time. I reset the report. Upon clicking the personal bookmark, the report drills Visual A down to Level 4 but does not apply any of the drill filters.

Working Bookmark Example:

Visual A has 4 levels of drill down available (Level 1, Level 2, ...). Each Level has 4 categories (A, B, C, D). At Level 1, I use drill mode to drill into Category 1-A and display Level 2. In Level 2, I use drill mode to drill into Category 2-C and display Level 3. In Level 3, I use drill mode to drill into Category 3-D and am now at Level 4, with drill filters applied for Level 1's Category 1-A, Level 2's Category 2-C, and Level 3's Category 3-D. I save a personal bookmark at this time. I reset the report. Upon clicking the personal bookmark, the report drills Visual A down to Level 4 and applies the drill filters from my original analysis (Category 1-A, Category 2-C, and Category 3-D).

 

Status: New
Comments
Community Support

@SkylerHaas_CMI ,

 

I could not reproduce this issue, could you please share a sample file for further analysis?(Do not post any sensitive data)

 

Regards,

Jimmy Tao

Regular Visitor

@v-yuta-msft Please provide an email to which I can provide additional materials. My organization does not support sharing of links to our OneDrive with outside entities, and the option to add a file to my comments is not available for me.

Here is comma separated data (please paste into a csv for use as a datasource in a pbix):

Level 1,Level 2,Level 3,Level 4,Value
1-A,2-B,3-C,4-B,5
1-B,2-B,3-B,4-C,3
1-C,2-A,3-B,4-A,3
1-D,2-A,3-A,4-D,9
1-D,2-B,3-B,4-B,3
1-A,2-B,3-A,4-B,8
1-C,2-D,3-B,4-B,10
1-C,2-B,3-D,4-C,1
1-A,2-C,3-C,4-C,4
1-D,2-D,3-B,4-B,1
1-C,2-B,3-C,4-D,9
1-D,2-C,3-C,4-C,2
1-B,2-B,3-A,4-D,1
1-A,2-C,3-A,4-B,1
1-D,2-C,3-B,4-B,7
1-D,2-B,3-A,4-D,7
1-D,2-C,3-B,4-A,5
1-C,2-B,3-B,4-B,10
1-C,2-D,3-C,4-A,8
1-A,2-C,3-B,4-D,6
1-A,2-B,3-A,4-B,8
1-B,2-A,3-A,4-D,6
1-B,2-A,3-A,4-A,1
1-B,2-A,3-B,4-B,1
1-D,2-B,3-B,4-B,2
1-B,2-C,3-A,4-C,10
1-C,2-B,3-C,4-A,8
1-A,2-D,3-D,4-B,7
1-C,2-B,3-C,4-D,4
1-D,2-A,3-D,4-B,1
1-C,2-B,3-A,4-B,1
1-D,2-D,3-B,4-C,4
1-A,2-A,3-A,4-D,8
1-C,2-D,3-A,4-D,8
1-C,2-A,3-D,4-D,6
1-D,2-A,3-C,4-B,8
1-D,2-D,3-C,4-A,10
1-D,2-D,3-C,4-C,9
1-D,2-D,3-B,4-D,8
1-A,2-A,3-B,4-B,7
1-D,2-C,3-C,4-A,3
1-D,2-A,3-D,4-C,2
1-C,2-C,3-C,4-C,6
1-B,2-A,3-C,4-B,7
1-C,2-D,3-C,4-B,3
1-D,2-A,3-C,4-D,5
1-B,2-C,3-C,4-B,1
1-C,2-D,3-D,4-A,5
1-C,2-D,3-B,4-B,2
1-A,2-A,3-C,4-B,1
1-C,2-B,3-D,4-B,7
1-B,2-D,3-D,4-D,7
1-B,2-A,3-A,4-D,6
1-A,2-B,3-C,4-D,1
1-D,2-D,3-D,4-D,2
1-D,2-A,3-B,4-A,5
1-C,2-A,3-D,4-A,9
1-B,2-A,3-A,4-B,6
1-D,2-D,3-B,4-D,8
1-C,2-B,3-C,4-D,3
1-A,2-D,3-B,4-A,2
1-C,2-B,3-C,4-B,5
1-A,2-D,3-D,4-B,10
1-C,2-C,3-C,4-A,8
1-C,2-A,3-A,4-A,9
1-B,2-B,3-C,4-D,10
1-A,2-C,3-B,4-D,9
1-D,2-D,3-C,4-B,10
1-C,2-D,3-A,4-B,2
1-D,2-D,3-A,4-A,8
1-D,2-A,3-B,4-C,1
1-D,2-A,3-C,4-B,3
1-B,2-C,3-B,4-B,4
1-A,2-B,3-B,4-A,4
1-C,2-D,3-C,4-D,4
1-D,2-D,3-B,4-B,9
1-B,2-B,3-B,4-B,6
1-B,2-D,3-A,4-D,9
1-C,2-A,3-A,4-B,6
1-B,2-D,3-B,4-C,5
1-C,2-D,3-B,4-B,9
1-B,2-D,3-B,4-B,1
1-D,2-B,3-B,4-C,2
1-A,2-C,3-A,4-C,6
1-B,2-D,3-A,4-D,3
1-A,2-C,3-D,4-B,7
1-D,2-C,3-A,4-C,7
1-B,2-D,3-C,4-C,8
1-A,2-C,3-D,4-C,7
1-B,2-C,3-A,4-D,8
1-B,2-A,3-A,4-A,3
1-D,2-C,3-D,4-A,4
1-A,2-B,3-C,4-A,6
1-B,2-A,3-D,4-C,8
1-D,2-B,3-D,4-B,2
1-D,2-C,3-A,4-C,5
1-C,2-B,3-B,4-D,3
1-B,2-B,3-B,4-B,4
1-D,2-B,3-A,4-B,10
1-A,2-A,3-D,4-D,2

Regular Visitor

Step by step pictures of a PowerPoint detailing how to recreate the problem using the data above:

Recreation Guide Page 1.jpgRecreation Guide Page 2.jpgRecreation Guide Page 3.jpgRecreation Guide Page 4.jpgRecreation Guide Page 5.jpgRecreation Guide Page 6.jpgRecreation Guide Page 7.jpgRecreation Guide Page 8.jpgRecreation Guide Page 9.jpgRecreation Guide Page 10.jpgRecreation Guide Page 11.jpgRecreation Guide Page 12.jpgRecreation Guide Page 13.jpgRecreation Guide Page 14.jpg

Regular Visitor

@v-yuta-msft 
Please confirm you have seen the additional information I've posted, as well as whether or not it is enough to act on. Thank you!