Forum Discussion

mark77's avatar
mark77
Helper I
5 years ago

Conditional Show Values in crosstable

My users would like a filter with (say) 20 measures. In this filterbox they wish to select which values / expressions shuold be calculated. ( Forecast, realization, profit, costprice etc).

Making a table with these measures to select them in a filter is not the problem.

 

Am I able to make a crosstable, where I make the visibility of my values dependent on the selections made in my filter table?

(Conditionally show the values).

 

Sometimes they just want the forecasrt. Sometimes just the realization.
They want a preset list of options.

 

I know they would be manually be able to update their values set, when selecting the vizualition and adding values.
But they find this to much work to constantly change.

 

Any recommendation?

 

Can I make individual values visble / invisible in my crosstable ? Based on selections in another table?

 

Need Help

11 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    How comfortable are you with Calculation Groups and Tabular Editor?  Would that be an option for you?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi mark77 ,

     

    First create a measure table as below:

     

    Then create a measure as below:

    Measure = 
SWITCH(
    SELECTEDVALUE('measure table'[Column1]),
    "measure 1",[Measure 1],
    "measure 2",[Measure 2])

    And you will see:

     

    For the related sample .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • mark77's avatar
      mark77
      Helper I
      5 years ago

      Hi! I'm dieing to see what the BPIX file does, but it appears to have an issue. I cannot open it with x64 December2020 version of powerbi. Do I need to install additional components ?

      I tried reinstalling PBI

    • edhans's avatar
      edhans
      Community Champion
      5 years ago

      v-kelly-msft can you please ensure you and your team are using publically released versions of Power BI? I have the latest from the app store and I cannot open this file.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi edhans ,

         

        Thanks for your notification,I have downgraded the desktop version,check my last reply.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!

    • mark77's avatar
      mark77
      Helper I
      5 years ago

      hi Kelly. Sorry for the delay. Had some eye troubles last week, so couldn;t really read any screens 😛

       

      Just tried your sollution, and it does not quite do what I want.

      I made a crosstable with "name" "measure1" and "measure 2"

       

      The fields "measure1" and "measure2" remain visible, despite what I choose in filter "column 1" where you prodvided the filter:

       

      Measure =
      SWITCH(
      SELECTEDVALUE('measure table'[Column1]),
      "measure 1",[Measure 1],
      "measure 2",[Measure 2])
       
      The idea is to be able to select which measures to show

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  mark77 ,

         

        Sorry for the late reply.

        Could you pls provide some sample data with expected output for test?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Looks like internally Microsoft is already using 2.90 while we are still on 2.88 - hopefully the february release will come out soon, and then you should be able to open the file.