Forum Discussion

Krunalbpatel's avatar
Krunalbpatel
Icon for Helper III rankHelper III
10 years ago
Solved

Display Each drill down level on report (Like - Breadcrumb)

Hi,   I want to display Hierarchy of each drill down level on a report. I want to display top drill down as a breadcrumbs in any site.   Suppose I have 3 different drill down level in a report T...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Krunalbpatel,

    We need to manually select different drill down levels in Hierarchy Slicer. And currently, it is not possible to display drill down level on the header, please vote this issue in the above idea.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Guys check out this. Works for me. Create it as measure and put it in a simple card visual...

Customer BreadCrump Navigation =

IF(ISFILTERED(CubeData[Customer Name]);LOOKUPVALUE(CubeData[Customer Name];CubeData[DIM_Customer_ID];max(CubeData[DIM_Customer_ID]))&" \ ";"No Filter \ ")
&
IF(ISFILTERED('Item'[Item_Brand_DE]);LOOKUPVALUE('Item'[Item_Brand_DE];'Item'[Item_Brand_ID];max('Item'[Item_Brand_ID]))&" \ ";"No Filter \ ")
&
IF(ISFILTERED('Item'[Item_CategoryName_DE]);LOOKUPVALUE('Item'[Item_CategoryName_DE];'Item'[Item_CategoryID];max('Item'[Item_CategoryID]));"No Filter")