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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Majad_Chowdhury
Advocate II
Advocate II

Create separate views for same dashboard

Hi Guys,

 

Is there a method to create 2 different views of the same report?

 

I have a report which is used internally by the business. Ideally we'd like to create a "Customer Version" of this report and be able to toggle between the 2. 

 

The most obvious solution would be to create another customer version of the report. But I was just wondering if theres something you guys may have done that has achieved the same functionality?

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @Majad_Chowdhury

 

1. Create separate views for same dashboard

If you're referring to the dashboard, you can't do that. Dashboards can only have one page and cannot be filtered or sliced.

vcgaomsft_1-1658404959253.png

 

2. If this is a report and there is no requirement for data segregation, you may consider BA_Pete's approach of using bookmarks and page navigators.

Create page and bookmark navigators - Power BI | Microsoft Docs

 

3. If you want your clients to open the report and only see the filtered data, you can consider setting Row-level security. This will restrict access to data at the row level for different roles.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

View solution in original post

4 REPLIES 4
v-cgao-msft
Community Support
Community Support

Hi @Majad_Chowdhury

 

1. Create separate views for same dashboard

If you're referring to the dashboard, you can't do that. Dashboards can only have one page and cannot be filtered or sliced.

vcgaomsft_1-1658404959253.png

 

2. If this is a report and there is no requirement for data segregation, you may consider BA_Pete's approach of using bookmarks and page navigators.

Create page and bookmark navigators - Power BI | Microsoft Docs

 

3. If you want your clients to open the report and only see the filtered data, you can consider setting Row-level security. This will restrict access to data at the row level for different roles.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

BA_Pete
Super User
Super User

Hi @Majad_Chowdhury ,

 

You've used both 'dashboard' and 'report' to describe the item that you want to be able to toggle. In Power BI, these terms are not interchangeable.

Are we talking about a report (created in PBI Desktop as a PBIX file), or a dashboard (created by pinning visuals from reports viewed in the PBI Service)?

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Hi, apologies

 

Read report for both terms!

 

No problem.

In that case, you probably want to look into using bookmarks:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop 

In the above, you will see that you can assign bookmarks to buttons, so you can add a toggle button of sorts using two different images (one toggled to customer, one to default) so that you can switch between the two views at the touch of a button on your report.

I'm assuming that any users you share the report with are authorised to see both versions of your report. If not, then you will need to create a separate report for anyone with different permissions on the information.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Kudoed Authors