Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
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
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.
User | Count |
---|---|
101 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |