Dynamic Table Columns

[bozdemir]

Hello,
I have my fact table at the very basic/leaf level. From this data, I am calculating, with measures, actuals for quarter to date, year to date, current month and comparing these actuals to budget, forecast, prev year, etc. If I want to put all of these actuals and variances on a page, it becomes very busy. Is it possible to give the user ability to select what she wants to see and the table just shows those actuals and variances?
For example, if the user selects "Variance vs Prior Year" for "Year to Date" actuals, then the table will show just those actuals and variances. If the user selects "Variance vs Budget" for "Current Month", then the table shows just those values.
Thanks in advance for your help.
Bulent

[amitchandak · Accepted solution]

@bozdemir , You can create tables to organzine the measure -https://youtu.be/b9oDIL8nbu0

There is object-level security. I am not sure you can use it in this case: https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-now-available-for-public-preview-...

Also explore calculation groups - https://www.youtube.com/watch?v=vlnx7QUVYME

[bozdemir]

Thanks very much @amitchandak@amitchandak .  I used Calculation Groups as shown in the youtube video you sent.  They work.  And also, I am a fan of Tabular Editor now. It is great!

Bulent