Forum Discussion

Tallone's avatar
Tallone
Helper I
9 years ago
Solved

PBI Desktop - Interactions

Hello, I have a dataset as below. the relationship of the data is as foll;ows: Each Loader has a Loader Desc. loader to desc is one to one, Desc to Loader is one to many. the relationship of Loader...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Tallone,

    In Power BI Desktop, we are only able to filter the other two slicers when selecting value in Loader, there is no automatic option to make the values in other two slicers ticked, we can only manually select values in the other two slicers.


    And in your sceanrio, you are not able to create relationships as mine when the fields in same table. You can review my example in the  attached PBIX file.


    Thanks,

    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Tallone,

How do you create relationships among the three tables? Please ensure that you set ”Cross filter direction” to “Both” as shown in the following screenshot.


I make a test using your posted data, and create relationships as shown in above screenshot, when I select value in each slicer, the other two slicers are filtered correctly. For more details, please check the attached PBIX file.


If you still have issues about the slicers, please help to post table structure with sample data and show us the relationships.

Thanks,
Lydia Zhang

Tallone's avatar
Tallone
Helper I
9 years ago

Hi Lydia,

 

The loader, loader description, and truck description are not in different tables. They are all attributes of every record in a Table containing truck payload (= total tonnes carried). Each record equals a single truck load.

 

Each Loader can load multiple Trucks and multiple Truck Descriptions. Each Truck can be loaded by multiple Loaders. Each Loader is a single Loader Description. Each Truck is a single Truck Description. Each Loader Desc can be multiple Loaders.

 

I am using this data structure to build a bar chart with the Bin as the X axis and the count in each Bin as the y axis. It's a histogram.

 

I've enclosed the table structure and some of the pertinent data as screen shots below.

 

Hopefully this information clears things up a bit ansd you now know my ultimate destination of the project

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Tallone,

    Using your sample data, I have no issues. When selecting value in each slicer, other two slicers are filtered.


    Thanks,
    Lydia Zhang

    • Tallone's avatar
      Tallone
      Helper I
      9 years ago

      Hi Lydia,

       

      Thank you for your reply. I may not have expressed what I am looking for clearly enough. In the worked example, what I am trying to do when you pick a Loader (in this case EX1849), is to have the Loader Desc associated with that particular Loader automatically ticked (in this case R996B) and which truck descriptions that the loader has loaded be ticked (in this case EX4500 and 793F).

       

      Also, I cannot replicate your linking because the fields in the sliders are all in the same table. How would I create the link you describe above between the fields in a table thather than between tables as is shown in the example?

       

      What am I missing here?

       

      Thanks,

      Mark

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Tallone,

        In Power BI Desktop, we are only able to filter the other two slicers when selecting value in Loader, there is no automatic option to make the values in other two slicers ticked, we can only manually select values in the other two slicers.


        And in your sceanrio, you are not able to create relationships as mine when the fields in same table. You can review my example in the  attached PBIX file.


        Thanks,

        Lydia Zhang