Forum Discussion
Dynamic Title When Drilling Down
Hello,
I am a new PBI user and I am having the hardest time creating a dynamic title for my chart when drilling down. I have been successful before when there is only one level two drill down but I am getting stuck with drilling down twice. Below is an example of my levels. Any assistance would be appreciated. Thank you!
Category
Subcategory
Product
djoellet
Try this:Title Label = Label = VAR Category = SELECTEDVALUE ( 'May 2022'[Category] ) VAR Subcategory = SELECTEDVALUE ( 'May 2022'[Subcategory] ) VAR Product = SELECTEDVALUE ( 'May 2022'[Product] ) RETURN IF ( ISINSCOPE ( 'May 2022'[Product] ), Product & " Detail", IF ( ISINSCOPE ( 'May 2022'[Professional Subcategory] ), Subcategory & " Detail", IF ( ISINSCOPE ( 'May 2022'[Category] ), Category & " Detail" ) ) )
3 Replies
- amitchandak
Super User
djoellet , Check for isfiltered or hasonevalue
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Thank you for your response! I wanted to provide additional details, below is the formula I am using:
Title Label =
var Category = SELECTEDVALUE('May 2022'[Category])
var Subcategory = SELECTEDVALUE('May 2022'[Subcategory])
var Product = SELECTEDVALUE('May 2022'[Product])
Return
IF (ISFILTERED('May 2022'[Category]),
Category & " Detail",
IF(ISFILTERED('May 2022'[Professional Subcategory]),
Subcategory & " Detail"),
IF(ISFILTERED('May 2022'[Product]),
Product & " Detail")
- SpartaBI
Community Champion
djoellet
Try this:Title Label = Label = VAR Category = SELECTEDVALUE ( 'May 2022'[Category] ) VAR Subcategory = SELECTEDVALUE ( 'May 2022'[Subcategory] ) VAR Product = SELECTEDVALUE ( 'May 2022'[Product] ) RETURN IF ( ISINSCOPE ( 'May 2022'[Product] ), Product & " Detail", IF ( ISINSCOPE ( 'May 2022'[Professional Subcategory] ), Subcategory & " Detail", IF ( ISINSCOPE ( 'May 2022'[Category] ), Category & " Detail" ) ) )
