Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm working on a report that measures the work efficiency of various technicians in the field.
The report has many pages and different measurements. To help users understand the report and navigate through it, I'm thinking of including a "Where to Find What" page that has a list of questions (that users are interested in) and a link to navigate to that page in the report. For example:
What SKU items are the most and least efficient?
What work order types are the most and least efficient?
Who are the top 10 most efficient and least efficient techs when onsite?
Who are the top 10 most efficient and least efficient techs overall?
Which tenure group performs the best and worst overall?
Which techs perform great onsite but overall efficiency is not optimal?
Etc.
3 questions:
1. How do I include a link to navigate to a page
2. Has anyone seen anything like this before?
3. Does anyone know of a website that has good formatting examples?
Thanks!
I'm looking for ideas on how to layout the page and was wondering if anyone has seen a good example of that?
Solved! Go to Solution.
Hi @ConnieMaldonado ,
Some design ideas for page navigation - I created a report sometime back which you can refer here:
https://datavibe.co.uk/f/global-oil-production-consumption-analysis
Regarding page navigations, you basically create buttons in Power BI and set an action on them to the page you want to navigate to. Refer following article on how to achieve this:
https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop
@ConnieMaldonado you can maintain this metadata somewhere outside, like an excel sheet where you can have the text and the link to the report, you can grab the link by going to each page in the service and get the web link.
You can use a table visual, with conditional formatting to the hyperlink (to the URL column). read more about this here Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
I hope this is helpful and get you started.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
AWESOME! Thank you.
Hi @ConnieMaldonado ,
Some design ideas for page navigation - I created a report sometime back which you can refer here:
https://datavibe.co.uk/f/global-oil-production-consumption-analysis
Regarding page navigations, you basically create buttons in Power BI and set an action on them to the page you want to navigate to. Refer following article on how to achieve this:
https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop
AWESOME! Thank you.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |