Dynamic Measures - Multiple Measures

Power BI Data Model
1

Hi All,

Was looking at your video on dynamic measures, is it possible to add multiple measures?

Also, is there a way to hide a column when the values or blank or zero?

I have different slicer options for users, but when i don’t select any of them, i want to hide the column! Is this something possible?

image
image.png560×511 47.8 KB

2

@balcey
Any chance you can upload some sample data and what you would like to see? There’s usually a wrinkle or two in people’s requirements.

Thanks,

Enterprise%20DNA%20Expert%20-%20Small

3

Hi Nick,

If i have selection in all three of my measure selection, i get the following view

image

If i have only 2 of the measures selected and set the 3rd to be blank, i get

image

Is there a way to hide the 3rd column?

Or is there a way to dynamically add multiple measures with one selection table? you can do that with unpivot dat but mine i spivoted and couldnt do multi select!

4

@balcey
I do not believe there is a way to have that hidden automatically. Couple workarounds could be to conditional formatting and set the background color to white. Or just create a bookmark.

Looks like you can vote to see if msft would add that feature
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33088639-hide-column-s

Enterprise%20DNA%20Expert%20-%20Small

5

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.