Conditional Show Values in crosstable

[mark77]

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?

[lbendlin]

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.

[v-kelly-msft]

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]

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]

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!

[mark77]

Hi! Please have a look at this included file.

Download PBIX from WeTransfer 

I tweaked your file to more show what I desire.

[edhans]

@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]

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]

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

[v-kelly-msft]

Hi  @mark77 ,

The version 2.90 has been released,you could download the latest version via below link and check my .pbix file,if you have other questions, welcome back to me.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Kelly

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

[v-kelly-msft]

Hi @mark77 ,

I have downgraded the version to November 2020,try again.

Best Regards,
Kelly

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

[lbendlin]

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