Forum Discussion

x0's avatar
x0
Helper I
2 years ago

Slicer Visual multiselection error

Hello Evevryone ,

 

Please help me with solve the query of multiselection on slicer i have been try using enable multiselect on visual settings appear some error with no data. here is screenshots 

screenshot number 1 :  with data on single selection 

 

 

 screenshot number 2 : multiselection but no data 

can i have any solution ? 

Note : I am using Messures from all table on single matrix value. 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Correct me if im wrong ....you want to multiselect a slicer but when u do it the data is not being displayed and error is shown!? 
    can you please share your data set for better understanding?

    • x0's avatar
      x0
      Helper I
      2 years ago

      Hello miTutorials 

       

      I solved the issue it was falut on messure i modified messure with in function now its is display 3 month data too i mean multi select is working 

      could you assit me on another query ? 

      let me share my sceanario on this dashboard as you can see 2 slicer 1 matrix and 123 card 

      now i am using this custom table for filter data so on 2 slic i add property column and Custom date column

      here is custom table which is take 3 information from all table 

      CustomTable =
      DISTINCT(
          UNION(
              SELECTCOLUMNS('Conversion', "LeasingAgent", LOWER('Conversion'[Leasing Agent]), "Property", 'Conversion'[Property], "CustomDate", 'Conversion'[CustomDate]),
              SELECTCOLUMNS('Move Insq', "LeasingAgent", LOWER('Move Insq'[Leasing Agent]), "Property", 'Move Insq'[Property], "CustomDate", 'Move Insq'[CustomDate]),
              SELECTCOLUMNS('J Turner Dashboard', "LeasingAgent", LOWER('J Turner Dashboard'[Leasing Agent]), "Property", 'J Turner Dashboard'[Property], "CustomDate", 'J Turner Dashboard'[CustomDate]),
              SELECTCOLUMNS('Online Review', "LeasingAgent", BLANK(), "Property", 'Online Review'[Property], "CustomDate", 'Online Review'[CustomDate]),
              SELECTCOLUMNS('Shop Report Tracker (2)', "LeasingAgent", LOWER('Shop Report Tracker (2)'[Leasing Agent]), "Property", 'Shop Report Tracker (2)'[Property], "CustomDate", 'Shop Report Tracker (2)'[CustomDate])
          )
      )

       

      now on matrix  column area i use leasing agent from custom table to see as header 

      and on 2 slic i add property and custom date from custom table 

      problem is on card 123 i use measure to see total or value 

      so on card i use this measure 

      Lead conversion First visit to 1 =
      ROUND(CALCULATE(
          DIVIDE(
              SUM('Conversion'[Applications Completed]),
              SUM('Conversion'[First visit/tour])
          ) * 100,
          ALLEXCEPT('CustomTable', 'CustomTable'[Property], 'CustomTable'[CustomDate])
      ),1

      )
      but it doesnt work mean showing me wrong value 
      but if i remove property and custom date from custom table and use own table column it is showing perfect value 

      highlighted part is my value on card here i am facing issue . 

       

      • x0's avatar
        x0
        Helper I
        2 years ago

        hello miTutorials 

         

        For your reference 

        this is original value but its comes with filter from conversion table i mean own table not from custom table.  and i would like to see this value on my main dashboard using custom table column filtering. 

         

         

  • FadilatBraimah's avatar
    FadilatBraimah
    New Member
    2 years ago

    Further clarification will help but this looks like there is an issue with your measures.
    Ensure you are using your aggregate functions correctly. be mindful of row and filter contexts in DAX. check for blanks and your data modeling.

  • miTutorials's avatar
    miTutorials
    Super User
    2 years ago

    It looks like in your measure you are using "Selectedvalue" Function to calculate. It will be good for you to post the measure here so that we can help you.

     

    Regards

    Ismail