Forum Discussion

karmptl701's avatar
karmptl701
Frequent Visitor
9 years ago
Solved

Select table accordingly for reports

I want my slicer to be drop  down and want to see only selected reports from slicer. For an example I want my slicer with drop down of dates and whenever the date is selected, I want to see whol...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi karmptl701,

    For your requirement, it impossible to achieve by slicer. Because when you use a slicer, all the values shown in the slicer come from one column in one table, and slicer used to filter the rows in same table. While you want to use the slicer value to filter different tables, which is irrelevant with the slicer feature.

    As the MFelix suggestted, you can combine all the tables to one by "Append" in Query Editor. But you need to recognise the AIR, GND,GND_TOTAL, INTL,USPS in different tables. 

    In addition, could you please add a date column in your resource table, and get a table like the following structure.



    Then you can use the custom slicer: HierarchySlicer, so that you can achieve the result as what you expected. When you click the date and dril down, you will get volumn field value.

    drill down

    Best Regards,
    Angelia

MFelix's avatar
MFelix
Super User
9 years ago

Hi karmptl701,

 

I didn't make myself clear on my question. How are you getting the data to PBI? multiple excel files/tabs, several SQL tables, how are you make the upload of the data so that you got 4/5 tables with dates?

 

You sould only make one single table to make it work better.

 

Regards,

MFelix

karmptl701's avatar
karmptl701
Frequent Visitor
9 years ago

Right now, I am getting it from my SQL Server. We have weekly basis HTMLs which we stored in database as binary objects. I am brining those HTMLs and saving each of them as a New Tables. Every week the date is change and the records too. All the records are numbers. And this is the way how I have to work with these.

 

Thank you.