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  ...
Need Help
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.