Forum Discussion

simrantuli's avatar
simrantuli
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Slicer selection not working for line

Hi All, I have 3 tables in my data model. Screenshot below. Basically, this is a survey data where Q1 & Q2 were two questions. People from various sites participated in this survey. Data of t...
Need Help
Tips and Tricks
  • simrantuli's avatar
    simrantuli
    5 years ago

    Thank you so much camargos88  & sfaizee for the answers.

     

    I was able to fix this by checking 'Show items with no data' for 'Response' under Shared axis.

     
     
     
simrantuli's avatar
simrantuli
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi camargos88,

 

Thanks for the answer.

Is there any way to make it work? I want to see the line if 'Global' is selected.

 

Thanks!

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

simrantuli ,

Try this measure:

Q1_Response_Site = CALCULATE(SUM(Q1[Response_Count]),Q1[Site]<>"Global") + 0
  • simrantuli's avatar
    simrantuli
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Hi camargos88,

     

    Thanks. It works.

    However, I see 'Global' twice in the legend now. One for Bar, whose value is 0 now, and the other for Line.

    Any way to get rid of the extra Legend value?

     

    Thanks!

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      5 years ago

      simrantuli ,

       

      Doesn't work for you if you just rename the line value like "Global - Line" ?

      • simrantuli's avatar
        simrantuli
        Icon for Continued Contributor rankContinued Contributor
        5 years ago

        camargos88 

        It will create confusions.