Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dynamic Filters on Dimension and Measures

Hi All, I want to display the diimension and their measures based on selection in the Table Visual. Like below Delivery Type, Brand, Manufacturer .... Materials these all are dimenssions and SKUs,...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

unfortuantely i don';t think switch will work on this, and I also thing selectedvalue is going to work , I just gave you an idea, selectedvalue only works if user select one value in the slicer.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Created a below column 

SelectedDim = IF(SELECTEDVALUE('Dimensions'[Dimensions])="Delivery Type",KPI_Sales[Delivery Type],"NUll") 

 

when I select Delivbery Type in slicer below it still does not refletc Delivery Type with its values form main table.

 

It seems Selected Value is not working for single value too.

 

Thanks

 

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    please add it as measure

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Adding it as measure will ask me to specify aggrgation....but I want that whole coulmn to display after selection and not aggrgated value.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      my mistake, yes, we need aggregation

       

      if("Delivery Option" IN VALUES(TableDimension[DimensionName]), MAX(Table[Delivery Option]), BLANK())

      You can work on this proposed solution but I don';t think it is very scalable and good approach, although at the same time I don't see any other solution.

       

      I will leave it upto you to make a decision to see if you want to continue on this path :)

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        :smileysad: