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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.