Hi I am building a dashboard for survey data and for reasons I am not quite sure I am running into a couple of problems.
I have five questions that I want to focus on. My dashboard looks like so:
1) I wrapped the text box at the top with a blank box that i removed the borders. When I ctrl and click each button to go to the bookmark I am unable to go to the state of the screen when boomarked. Each bookmark is supposed to show their corresponding box highlighted.
2) I am having trouble creating the title card for stacked chart on the left. I want to create a title card or text box that removes the "Count of" part off the bottom line. The title of the chart ain't much better and is much worst and I have removed it from the above picture. It says "Count of On scale 1 to 10, how satisfied are you with your current job? by On scale 1 to 10, how satisfied are you with your current job?". I am not sure what I can do to make it more presentable.
3) I wrote a dax query for the title that seems to work. It's
Departments = IF(
ISFILTERED(Tbl_Department[Department]),
If(HASONEVALUE(Tbl_Department[Department]), "Opinions of the " & values(Tbl_Department[Department]) & " Department", "Opinions of " & CONCATENATEX(Tbl_Department, [Department], " | " )), "Opinons of All of the Departments")
4) can I have some design ideas as well to make the dashboard sing. I have not included the date or survey type because they felt mostly redudant and I felt the title I had above was long enough as it is without it leading to potential stuff like "Opinoins of Finance | Accounting | IT department that were surveyed by Phone and Email.
Thanks in advance
I have five questions that I want to focus on. My dashboard looks like so:
1) I wrapped the text box at the top with a blank box that i removed the borders. When I ctrl and click each button to go to the bookmark I am unable to go to the state of the screen when boomarked. Each bookmark is supposed to show their corresponding box highlighted.
2) I am having trouble creating the title card for stacked chart on the left. I want to create a title card or text box that removes the "Count of" part off the bottom line. The title of the chart ain't much better and is much worst and I have removed it from the above picture. It says "Count of On scale 1 to 10, how satisfied are you with your current job? by On scale 1 to 10, how satisfied are you with your current job?". I am not sure what I can do to make it more presentable.
3) I wrote a dax query for the title that seems to work. It's
Departments = IF(
ISFILTERED(Tbl_Department[Department]),
If(HASONEVALUE(Tbl_Department[Department]), "Opinions of the " & values(Tbl_Department[Department]) & " Department", "Opinions of " & CONCATENATEX(Tbl_Department, [Department], " | " )), "Opinons of All of the Departments")
4) can I have some design ideas as well to make the dashboard sing. I have not included the date or survey type because they felt mostly redudant and I felt the title I had above was long enough as it is without it leading to potential stuff like "Opinoins of Finance | Accounting | IT department that were surveyed by Phone and Email.
Thanks in advance