How to make a gap between bars for different catagories

[Anonymous]

Hi, I have a graph like this. How can i make a gap in the arrow place to separate between different codes which are 24, 25, 5E, 7R, 8L etc.?

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

True =
var _table1=
DISTINCT(
    'Table'[Group])
var _table2=
ADDCOLUMNS(
    _table1,"Flag",
    [Group]&"-"&"Group")
var _table3=
SUMMARIZE(
    _table2,[Flag])
var _table4=
UNION(
   _table1,_table3)
return
CROSSJOIN(
    DISTINCT('Table'[Date]),_table4)

2. Create calculated column.

Flag =
var _if=
IF(
    'True'[Group]in SELECTCOLUMNS('Table',"1",[Group]),1,0)
return
IF(
    _if=1,
    SUMX(        FILTER(ALL('Table'),'Table'[Date]=EARLIER('True'[Date])&&'Table'[Group]=EARLIER('True'[Group])),[Value])
    ,
IF(
   'True'[Date]=
    MINX(
       FILTER(ALL('True'),'True'[Group]=EARLIER('True'[Group])&&NOT('True'[Group])in SELECTCOLUMNS('Table',"1",[Group])),[Date]),       
        0     
        ,BLANK())
)

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...