Forum Discussion

andy808's avatar
andy808
Icon for Resolver I rankResolver I
2 years ago
Solved

Click Project name on a visual and have that Project name sync/apply to all pages-not drill through

I have a visual where users can select a Project

I have Project slicers on all pages that are synced

 
When the user selects a Project name from Project Slicer, I get the requirement that the Project Name is pre-selected/filtered on all pages.
 
But - now I am using a gantt chart and the user wants to select a project from the visual (not from the Project slicer) and have that selected project sync to all pages. Not a drill through. 

Is it possible to select a Project name from any visual and have that selection "sync" / carry through to other pages?

 

If it helps - I have a dynamic title that displays the Projects selected on visual or Slicer:

 

I have a dynamic report title that displays the report name chosen on a visual or on the Project Slicer.

TitleProjectList =
VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('Projects'[ProjectName])
VAR __MAX_VALUES_TO_SHOW = 4
Var StaticText = "Project List: "
RETURN
IF(ISFILTERED(Projects[ProjectName]),
    IF(
        __DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW,
        CONCATENATE(
            StaticText&
            CONCATENATEX(
                TOPN(
                    __MAX_VALUES_TO_SHOW,
                    VALUES('Projects'[ProjectName]),
                    'Projects'[ProjectName],
                    ASC
                ),
                'Projects'[ProjectName],
                ", ",
                'Projects'[ProjectName],
                ASC
            ),
            ", etc."
        ),
        StaticText&
        CONCATENATEX(
            VALUES('Projects'[ProjectName]),
            'Projects'[ProjectName],
            ", ",
            'Projects'[ProjectName],
            ASC
        )
    ), "Project List:")

 

Thank you for any help here 🙂

Need Help
  • andy808's avatar
    andy808
    2 years ago

    Thanks for the quick response, I gathered that but was hopeful some DAX would solve my challenge. I tried a button but I can only control to 1 page by navigation like a drill through essentially, it doesnt help the filtering to all the other pages

     

  • parry2k's avatar
    parry2k
    2 years ago

    andy808 YUP, will not work, only to one page. Basically, sync slicer is the way to go, and I cannot think of the DAX way. Once we have the option to set a default value for the slicer then there might a DAX tricks but cannot think of that now. 

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    andy808 you cannot sync the selected option from a visual to the other pages. Sync slicers is the way to go or as you mentioned, drill through but I guess that is not what you are looking for. 

    • andy808's avatar
      andy808
      Icon for Resolver I rankResolver I
      2 years ago

      Can I ask you another quick Q? 

      What is the DAX for distinct count of Project Names based on Risks?

      i.e. There are 8 Project Names for 20 Risks. (the 2 columns are from different table)

       

       

  • andy808's avatar
    andy808
    Icon for Resolver I rankResolver I
    2 years ago

    Thanks for the quick response, I gathered that but was hopeful some DAX would solve my challenge. I tried a button but I can only control to 1 page by navigation like a drill through essentially, it doesnt help the filtering to all the other pages

     

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    andy808 YUP, will not work, only to one page. Basically, sync slicer is the way to go, and I cannot think of the DAX way. Once we have the option to set a default value for the slicer then there might a DAX tricks but cannot think of that now.