Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicers

Hey, In my report I want to compare the turnover of the selected branches to a benchmark. This benchmark can be selected as well. I do this via two slicers, one for the selected branches and one for...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    I reached your expected output with two methods but both of them need extra tables. As you have found, when you select some options in the first slicer, the second slicer will be filtered and the column chart too. So adding a disconnected table that contains values for the second slicer is a solution to solve this. You can add a table easily by DAX codes like:

     

    Benchmarks = VALUES(Table1[Branch])

     

     

    And I created measures to calculate the value for the selected branches and benchmark separately. The result is as below. Please download the .pbix file for more details.

    Selected Branches Total = SUM(Table1[Kolom 1])
    Benchmark Total = SUMX(FILTER(ALL(Table1),Table1[Branch]=SELECTEDVALUE(Benchmarks[Branch])),Table1[Kolom 1])

    Kindly let me know if you have any questions.

    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak 

So I have the following data

And then I select A and B in a slicer and in a separate slicer I select C as the benchmark. Then I want to output for example the following which I don't know how to do. As the first slicer excludes C from being shown and the second excludes A and B from being shown.

 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

 

I reached your expected output with two methods but both of them need extra tables. As you have found, when you select some options in the first slicer, the second slicer will be filtered and the column chart too. So adding a disconnected table that contains values for the second slicer is a solution to solve this. You can add a table easily by DAX codes like:

 

Benchmarks = VALUES(Table1[Branch])

 

 

And I created measures to calculate the value for the selected branches and benchmark separately. The result is as below. Please download the .pbix file for more details.

Selected Branches Total = SUM(Table1[Kolom 1])
Benchmark Total = SUMX(FILTER(ALL(Table1),Table1[Branch]=SELECTEDVALUE(Benchmarks[Branch])),Table1[Kolom 1])

Kindly let me know if you have any questions.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.