Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Matrix - Add some blanks Column to separate 2 measures

Hi, I am fairly new to Power Bi.

I want to Add blank Column to separate 2 measures like this,

How can i to do this like excel

555.png

Thank you

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

You can create a new column in any table and use it

 

1 = BLANK()

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

View solution in original post

@Anonymous 

 

In the Format section of the Visualizations pane, expand the Field formatting card, then you may change Font color, Background color and turn Apply to header On.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Prabhu_MDU
Advocate I
Advocate I

How to make a column as blank based on a measure value. 

 

Measure = IF(SELECTEDVALUE('Table'[Column])="Value",1,0)

 

This measure is based on a Slicer value.

if this measure returns 1 then I want to display the column else I want to make the column as blank. 

 

please suggest how this can be achieved

amitchandak
Super User
Super User

You can create a new column in any table and use it

 

1 = BLANK()

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Anonymous
Not applicable

Howerver,I want the blank header and its background are also white.

If only create "=blank()",it can not be

@Anonymous 

 

In the Format section of the Visualizations pane, expand the Field formatting card, then you may change Font color, Background color and turn Apply to header On.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.