Forum Discussion

michael95677's avatar
michael95677
Icon for Helper III rankHelper III
4 years ago

I need dynamic titles for visualization drill down sub reports

I've tried wriring a Measure but it does not really pull the date, just shows the text in the quotes mostly. 

 

AppointmentTitle =
var ApptDates = SELECTEDVALUE(ApptsNext7Days[ApptDate].[Day],"ApptDay")
RETURN
"Appointments for Date of " & ApptDates

8 Replies

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where you are stuck?

  • When you click on a date it drills down into the detail but the title does not reference anything to do with the date that the user is looking at in the drill down. I need the ability to change all titles on all drill downs in general to reference what is being reviewed in that drill down rather than the title from the parent page/visualization. If you hover over the detail it does show the date you are on but the title does not. 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Would you be able to share a sample PBIX ?

  • Thank you for the reply. It would not be best for me to share the pbix at this point. I was just hoping that this would be a fairly simple solution. If I have a date on top or parent level and select that date, I just want it to somehow reflect in the drill down that shows the detail for that date. Just want to know how to dynamically assign a title to the drill down. Some kins of DAX I'm assuming? Thanks

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      I didn't ask for your original pbix. But without sample data that illustrates the issue it is hard to provide guidance.

      • michael95677's avatar
        michael95677
        Icon for Helper III rankHelper III

        What is the best way to provide what you request? Fairly new to Power BI so still a little confused as to why some things that should be so easy are not. 🙂