Forum Discussion
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
Thank you
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-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Anonymous
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.
4 Replies
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-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Anonymous
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.
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
