Forum Discussion

gtamir1's avatar
gtamir1
Helper I
4 years ago
Solved

filtering summarized table

Hi, I have a summarized table based on Sales table. The summarized table does not have dates. I wand to show graphes from the summarized table, filter by months. If I use a slicer with months for t...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi gtamir1 ,

     

    I don't have access to the link you shared, so I created the following sample data.

     

     

    You can try using the query parameters to filter the months.
    1. First add column [Year_Month] as a new query, then remove the duplicate values.

                        

     

    2. Create a parameter and references query Year_Month.

     

     

    3. Filter the rows in column [Year_Month] equal to the parameter.

     

          

     

    4. Then you can modify the parameter to change the data loaded into the model.

     

                

     

    Alternatively, if you are using the DirectQuery mode and the data source meets the following restrictions, then you can try using the Dynamic M query parameters.

     

    • The feature is only supported for M based data sources. The following DirectQuery sources are not supported:
    • T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (such as Azure Synapse Analytics (formerly SQL Data Warehouse)), and Synapse SQL OnDemand pools
    • Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
    • Other unsupported data sources: Oracle, Teradata, and Relational SAP Hana, PostgreSQL
    • Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kumail's avatar
Kumail
Impactful Individual
4 years ago

Hello gtamir1 

 

The options given by bcdobbs almost covers all the scenarios.

 

If you could send sample .pbix file, this would enable to better understand your requirements and giving a working solution.

 

Regards

Kumail Raza

    • Kumail's avatar
      Kumail
      Impactful Individual
      4 years ago

      Hello gtamir1 

       

      The table referred to in the file seems missing. 

       

       

      • gtamir1's avatar
        gtamir1
        Helper I
        4 years ago

        Yes I just sent the importent tables. "creditcard" is the sales, and 

        "RunningTotalByCreditCard".
        I want to filter         RunningTotalByCreditCard by month(s).
        v-kkf-msft gave me a solution but I would like to multiple filter, and to leave on tab unfiltered.

         

      • gtamir1's avatar
        gtamir1
        Helper I
        4 years ago

        Hi Kumail 
        Thank you for your effort.

        I don't know what you did but the numbers are incorrect.
        If I filter the creditcard file in power querry for one year, this is what v-kkf-msft does too with a parameter, I then count cards in "C" in the summarized table and get different numbers then yours.
        You can export it to excel and play with it.

  • gtamir1's avatar
    gtamir1
    Helper I
    4 years ago

    Thanks Kumail I granted your permition request for google drive.