Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
1 year ago
Solved

How to Create a click for more details button...

Hi - I am looking to do the following:

I have a measure that stores a specific value (example: kpi-store-name).

The kpi-store-name is one specifi name (value).

How do I create a button that passes the measure kpi-store-name to a specific sheet and the visualization on that sheet automatically filters to the vale of kpi-store-name ?

 

Any thoughts would be appreciated - Jerry

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jerryr125 ,

     

    Please try to create the calculated table using the below query.

     

    FilteredTopStores =
    VAR TopStores =
        SUMMARIZE(
            FILTER('abc', [OpenOrders] = "Y"),
            [StoreDesc],
            "ct", COUNTROWS('abc')
        )
    VAR TopStoreNames =
        CONCATENATEX(
            TOPN(1, TopStores, [ct], DESC),
            [StoreDesc],
            ","
        )
    RETURN
        FILTER(
            'abc',
            CONTAINSSTRING(TopStoreNames, [StoreDesc])
        )
     
    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

    Regards,
    B Manikanteswara Reddy

6 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Icon for Super User rankSuper User
    1 year ago

    Hi jerryr125 You could try these please 

    Create a bookmark: This helps define the target sheet and its current state.

    Add a button: Which will serve as the clickable element that navigates to the bookmarked sheet.

    Use a slicer or filter: Dynamically passes the value of the measure (kpi-store-name) to ensure filtering works.

    Apply the filter to the target sheet: Ensures the bookmark reflects the filtered state based on the passed value.

  • jerryr125's avatar
    jerryr125
    Icon for Helper IV rankHelper IV
    1 year ago

    Hi - 

    I did the following:

    - Created a page

    - On the page I have simple table visualization

    - In the visualization, I added "kpi-store-name" as a filter

    - In the filter settings, I have the "kpi-store-name" set to Show items when the value "is not empty"

    (which does not filter on the specific store name)

    - Created a bookmark "Home-KPI"

     

    For the button:

    - I set the button to go to the bookmark

    - The button works but the filtering does not happen.'

     

    Note: the measure for the "kpi-store-name" is 

     

    var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))
    return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])
    * This measure works and returns the store name with the greatest number of OpenOrders
     
    I would like for the user to click the button to see the specific orders
     
    Any thoughts ?
    • jerryr125's avatar
      jerryr125
      Icon for Helper IV rankHelper IV
      1 year ago

      Akash_Varuna 

      Hi - Any thoughts or suggestions ? I did try this  and unfortunately it did not work.

      Thanks - Jerry

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jerryr125 ,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

    Thank you Akash_Varuna , for your quick response.

     

    To better assist you, could you please share a sample of your dataset along with the expected result/output you're aiming for? This will help us understand the structure and logic you're working with.

    Kindly avoid including any sensitive or personal data—just a simplified version that reflects the issue is perfectly fine.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

    Regards,
    B Manikanteswara Reddy

    • jerryr125's avatar
      jerryr125
      Icon for Helper IV rankHelper IV
      1 year ago

      Hi Anonymous 

      Thank you for your help.

      Example:

      tbl_abc

       

      StoreDescOpenOrdersOrderID
      StoreAYa1
      StoreAYa2
      StoreAYa3
      StoreBYa4
      StoreBYa5
      StoreBYa6
      StoreCYa7
      StoreCYa8
      StoreDYa9

       

       

       

      KPI-TOP-STORES = 

      var a = SUMMARIZE(filter('tbl_abc',[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))
      return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])
      * This measure works and returns the store name(s) with the greatest number of OpenOrders
      Example Results:
      StoreA
      StoreB
      (since they both have the same number of openorders (3)
       
       
      A sheet with the table visualization, I only want to show the values for StoreDesc = KPI-TOP-STORES
       
      The results of visualization would be:
       
      StoreDescOpenOrdersOrderID
      StoreAYa1
      StoreAYa2
      StoreAYa3
      StoreBYa4
      StoreBYa5
      StoreBYa6
       
      any thoughts ?? thanks 🙂 
      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi jerryr125 ,

         

        Please try to create the calculated table using the below query.

         

        FilteredTopStores =
        VAR TopStores =
            SUMMARIZE(
                FILTER('abc', [OpenOrders] = "Y"),
                [StoreDesc],
                "ct", COUNTROWS('abc')
            )
        VAR TopStoreNames =
            CONCATENATEX(
                TOPN(1, TopStores, [ct], DESC),
                [StoreDesc],
                ","
            )
        RETURN
            FILTER(
                'abc',
                CONTAINSSTRING(TopStoreNames, [StoreDesc])
            )
         
        If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

        Regards,
        B Manikanteswara Reddy