Help with creating Groups of columns to be used with Field parameter

[Sushil03]

Hello,

Currently I am trying to achieve something like this in Power BI along with field paramaters, allowing user to choose what columns he/she wants to see in the table.


I successfully used field paramters to show/hide the columns by selecting an option from a dropdown

But I want to show a parent header(like a hierarcy) on top of the columns like it is in image1.
Can someone help me find a solution to tackle this problem ?

[SamWiseOwl]

@Sushil03 you still need the original column in the visual so Query1 Performance Metrics as well as the group column

[Sushil03]

Hi @SamWiseOwl 

I had tried that as well.

[SamWiseOwl]

Do you have something ticked in the slicer? Having nothing selected could also cause an error.

[Sushil03]

No, I have not selected anything

[SamWiseOwl]

Have you tried using it in a matrix?
I'm afraid I'm not sure why this is erroring both visual types should work:

The only way I can get the same error is by forcing an invalid filter. Here I'm filtering by the Measure 1&3 group but in the other slice choosing Measure 2.

Try filtering in the GROUP slicer to just one item.

Does it error then?
Could one of your data fields be clashing with a measure?

[Sushil03]

I used matrix and it is still the same (with 1 group selected in the slicer)

[SamWiseOwl]

Apologises @Sushil03 I might need to leave it for someone else to solve.

Without the file I can't work out from my end why it won't work.

It works in my test file 🤔

[Sushil03]

Here's some dummy data, if you want to try.

https://drive.google.com/file/d/1VXJuU_nyROqRiJQbQO53hx920o7NnoYe/view?usp=sharing

I am trying to achieve something like this but with field parameters(ability to hide/show group of columns)

[SamWiseOwl]

Hi @Sushil03 ,

I see, you are using columns within the category groupings instead of measures. Meaning the new column tries to introduce a filter that doesn't exist.

You can either use the grouping only in the slicer (page 1) or you can create measures for each of the calculations, then repeat the steps we did before (page 2).

I've attached both examples here.

I'd check out the SQLBI youtube channel for a deep dive into how these filters work or check out the free Wise Owl video course here.

[SamWiseOwl]

Hi @Sushil03 

Assuming you created the measure list using Modeling and Field values:

Go to the table that was created Right click on the first column and choose New Group:

Then group the items together like so:

Use this field in your slicer and columns of your matrix:

If this helps please mark it as a solution for others to find 🙂

[Sushil03]

Hi Sam,
Thank you for the reply.
One question, will this work for a table or will have to change it to matrix ?

if I add Query1 Performance Metrics(groups) to columns it gives me error