ADWISE RoadMap – ChangeLog

Version 3.1

RELEASED! Due to specific Microsoft publishing process, it may not reach all of you at the same time. General availability end of February 2024.
This release will be minor one, but we added some useful features and couple things for making your roadmaps nicer 🙂

IMPORTANT! License key input now in the formatting menu as a first option. No more cumbersome green „License key“ button in the upper left corner of the visual.
No need to enter the license key anew, unless you are renewing your license.

New features

  • New license key input method – green „License key“ button exchanged for item in formatting menu
  • Line Breaks – content can be spread on multiple rows (e.g. Additional column content). It can be done by simple line breaks in source excel or UNICHAR(10) in calculated columns. See Additional column content in „Case No. 1 Alt 2“ and its dataset in demo files.
  • „Empty“ visual message – configurable (message, icon on/off)
  • Multiple select for bars/milestones

Look & Feel

  • First/last row – we have revamped the presentation of these rows to be more „in line“ with the rows between
  • Whole row coloring – based on Group/Subgroup color
  • Display milestones on collapsed levels
  • Left Axis/Additional column background
  • Horizontal Time Interval Zoom – you can zoom down to minutes (5 minutes intervals)
  • Default zoom level

Bug fixing

  • Milestones shapes and size persistency
  • Legend – correctly showing categories when filtering

Version 3.0.6

RELEASED General availability mid November 2023
This release is a service one, focused on bug fixing.

IMPORTANT! If you are using Color by Ranges for Milestones, it might not work properly and you will have to reset your ranges settings. We are sorry for any inconvenience.

New features

  • „Empty“ visual message – if there is nothing left to show (e.g. all data is filtered out, …), the message is displayed

Bug fixing

  • Time Axis resizing – Time Axis now resizes corretly when data time span is changed (e.g. when filtering data)
  • Turning On/Off weekends in TimeAxis menu is now working as expected
  • Ranges color for Milestones corrected
  • Horizontal bars now showing when needed
  • Http/Https connections – visual works for both connections/protocols (e.g. on your internal servers, with some third party SW, etc.)

Version 3.0

RELEASED General availability on June 28th 2023

IMPORTANT! Please, pay attention to fiscal year settings on Time Axis. To be able to accomodate all possible fiscal year combinations, we had to change fiscal year settings and it can affect your actual appearence of Time Axis – labels of fiscal years and time axis intervals (different start of fiscal year). We are sorry for any inconvenience.

New features

  • Tree vs. Table view/hierarchy
    • You have 2 distinct options to organize hierarchy in Left Axis – Tree view with summary bars or more condensed Table view
    • New Table view allows you to have more rows visible while preserving hierarchy
    • You can easily choose the view in Left Axis settings
    • See our new demo files Case #2 for practical difference between Tree and Table view
  • Addional column content mapping
    • We have added new field to Fields pane „Additional column content“ to easily map the column content
    • You do not have to specify column content in your source data, you can just map any field or even measure into the field and it will appear in Additional column
    • Don’t forget you map the content for row (not single bar, etc.), so you must specify what calculation should be used when muiltiple values for one row are found (e.g. imagine you have multiple campaigns with expenses on the same row and you want to sum the expenses in Additional column)
    • New setting in menu Additional column – option Display (either Description field – same as before form your source data or calculation formula)
  • Sorting by date or by aplhabet
    • New menu for Sorting either by date/time or alphabetically + ascending/descending option
    • Sorting field is left if you want to apply some more sophisticated sorting algorithm (if you have this field mapped, the new menu will not appear in formatting settings)
  • Multiple Target lines/intervals
    • You can set as many Target lines and even Target intervals as you want/need – they will appear from top to bottom of the visual and can have titles/labels
    • They have to be specified in your source data – new data type „Target“
    • Targets formatting settings are based on Category field (same as for Bars/Milestones), so there is new formatting menu „Target Category Colors“ at the bottom of formatting pane (visible only when you have Targets in your source data)
    • See our new demo files Case #4 for multiple Targets
  • „Today“ focus
    • If enabled, it automatically centers visual display around today date each time the visual is updated (= reopened or shown again when returning from another report page)
    • New option in Zoom and Focus menu (previously known as Zooming menu)
  • Weekends On/Off
    • Weekends can be included/excluded from showing on Time Axis and can can also be formatted with different color
    • Settings and formatting for weekends color is available in menu Time Axis

Look & feel changes

  • New shapes for bars
    • Now you can choose from rectangle, skewed rectangtle (left/right), process arrows and process arrow with flat start
    • Main and additional bars can be changed separately (e.g. if you want your plan bar to look different than main bars)
    • Settings in formatting menu Bars
  • Text/Labels truncating
    • Truncating means to shorten the text with „…“ at the end to fit the assigned space (e.g. width of the bar, etc.)
    • It can be set in corresponding menus option „On text Overflow“/“Truncate Text“ – applies to Bars, Groups/SubGroups, Left Axis
    • „Truncate Text“ – text is truncated for one line only, for „Wrap Text“ option the text is automatically truncated on the last line (if it does not fit in the space)
  • Plan Bar positioning
    • Plan bar can be positioned „On top“, „Behind“ and now „Below“ Main bar
    • Thus all your text/labels within Main bar will be clearly visible
  • Milestones repositioning + text width
    • Yes, we know that milestones positioning is problem, especially when there is more milestones close together 🙂
    • Thus we are introducing experimental feature to automatically reposition milestones (horizontally)
    • New option in menu Milestones/On text overlapping/“Reposition and Show all“
    • Also, there is a new option to set „Max Text Width“ for Milestones labels/texts (-1 means show full and any other value set specific text width for all Milestones)
  • Column labels
    • Group, SubGroup and Left Axis columns now can have labels
    • Left Axis label moves when mouse over to see collapse/expand arrows
    • Labels are automatically truncated
  • Conditional formatting
    • Conditional formatting enabled for Bars/Milestones colors (only, not shapes, etc.)
    • In Bars/Milestones menu there is a new „fx“ next to Default Color, it brings you to the standard Power BI conditional formatting menu

Other

  • Significant performance improvements especially for large data sets …
  • Updated demo files + Tips – redesigned demo files including new demo cases and Tips (available on the release date)
  • Some bug fixing

Version 2.6

RELEASED General availability start of February 2023
This release is a service one – more about bug fixing and small changes.

New features

  • Hour time interval
    • The smallest time interval is now hour (e.g. for shift planning etc.)
    • You can choose from 12H/24H format for showing time in Time Axis setting
    • When any time axis is showing hours, the hours (time) from the source data are fully respected. Otherwise, if there’s a non zero time in source data, this time is respected regardless of what the view scale is.
    • Also, the minimal Nice range value is now day, to better work with hour intervals
  • Other
    • DIN font added

Bug fixing

  • When main bars are overlapping and additional bar is OFF or is BEHIND main bar, bar texts are not overlapping anymore
  • Color by Ranges setting is now working
  • Legend fixes: When groups are not visible and bars are colored by groups, group colors show in Legend. When colored by ranges, legend shows used ranges and their colors, Legend colors reflect opacity of bars / milestones
  • When milestones placed at the bottom of bars, the milestones of the most bottom bars are visible
  • Expanding/collapsing arrows hide when Left Axis is hidden
  • Zooming and scrolling panel positioning is improved if the height of the chart is too low

Version 2.5

RELEASED General availability on October 5th 2022

IMPORTANT! Automatic update from AppSource may cause „swapping“ of mapped fields in current reports – most probably swapping of Axis Y and Group fields. You have to remap the fields back. And in some cases, there can be variations in Category settings (colors, …) for Milestones.
We are sorry, but we hope, that the large set of new features compensates for a possible rework. Thank you for understanding.

New features

  • Tree hierarchy
    • Expandable/collapsible tree levels within Left Axis with separate formatting and indentation (+ levels can be combined with Group columns)
    • You can set up to 4 levels of hierarchy
    • All level fields to be mapped in Fields pane in Axis Y [1-4] – data source structure in columns
    • Formatting – indentation depth (Left Axis, Margin Width per Level“ in pixels), font color and style (regular, bold, italic, bold italic)
  • SubGroup
    • You have one more hierarchy level (column on the left side) to show in the visual – Groups can be divide to SubGroups
    • You can map another field in Fields pane in „Group, SubGroup“ field – so both Group and SubGroup are mapped in one field
    • Formatting settings same as for Group
  • Actual vs. Plan in Bars
    • Mainly used for plan or baseline visualisation/comparison – you can set, which Bar is main and which additional
    • There is new Type (data type) for visualisation Plan (apart from Milestone and Phase)
    • Formatting settings – On/Off, opacity (of main and additional phase/bar), height and positioning (on top or behind main bar)
  • Additional info column
    • You have space for any additional information you want to display (for row) – new column with its own title
    • There is new Type (data type) for visualisation InfoColumn (apart from Milestone, Phase, and Plan)
    • Column positioning – on the left or right side of the visual
    • Formatting – both title and content independently (font, size, color)
  • Legend
    • Legend is automatically generated from Category field for Bars and/or Milestones
    • Independently turn On/Off for Bars and Milestones, independent titles for both
    • Legend placement – left/right/top/bottom of the visual and alignement
    • Formatting – font, size, color
  • Fiscal year logic
    • You can set the month for start of fiscal year, thus the Q1 will start in the corresponding month
    • When Fiscal year is different from calendar year, the years will start with „FY….“
    • You can set the fiscal year in Time Axis menu
  • Time interval/period zoom
    • Horizontal zooming can be set to time interval, so you can zoom by day/week/month/quarter/year
    • Formatting menu Zooming – you can set initial zoom period + max and min zooming period (e.g. to prevent to zoom to the day detail when large time span is shown in the visual
  • Go To Today
    • New button in zoom controls – quickly center visual around Today date

Look & feel changes

  • Row background
    • Background color can be set independently for odd and even rows
    • Formatting menu Left Axis, option „Striped Row Background“
    • Also you can set for Groups to always start with the same color – Left Axis, option „Group Always Starts Odd“
  • Milestones positioning
    • Milestones shapes + text/labels can be positioned on the top or on the bottom of the Bars
    • Placement option in menu Milestones
  • Milestones auto-fit
    • To have more flexibility with Bars and Milestones fit within the row (menu Milestones, option Auto-fit into Chart On/Off)
    • When „On,“ the position of Milestones and Bars will be calculated to fit them together, so both will be positioned to accomodate the row height in best possible way (this is same as in previous versions)
    • And when „Off,“ the bars will be in the middle of the row height and Milestones will be displayed on Bars (even if it means they will be overlapping with another row content)
  • More control over Gridlines
    • Horizontal Gridlines – you can turn On/Off Gridlines for each row (not only for Group), menu Left Axis
    • Vertical Gridlines – you can turn On/Off Gridlines for vertical (time) intervals, menu Time Axis
    • Gridlines colors can be set in menu Left Axis or Time Axis (independently for ticking and additional interval)
    • Also Gridline for Groups color can be set up (menu Group)
  • Group/SubGroup background
    • Background color of the Group text/label can be set in menu Group colors – background is indicated as [BG]
    • SubGroup color is same as for Group, but you can apply „Background Striping“ – SubGroup background colors will be brighter and alternates for each SubGroup (menu SubGroup/Background Striping On/Off)
  • Left Axis
    • Left Axis line can be turned On/Off – menu Left Axis/“Show Axis Lines“
    • Letter spacing for Left Axis labels/texts
  • Time Axis
    • Height of tick marks can be set for main and additional time axis (in % of axis height)
    • Formatting menu Time Axis, option Tick size %

Other

  • Zooming – when „Zoom by row height is applied,“ the +/- button is functioning only for horizontal zoom (not vertical)
  • Milestones Category settings – milestone settings (shape, size, color) based on Category are now in standalone menu (same as for Bars)
  • Dynamic font size (beta) – automatic adjusting of font size in Bars when zoom is applied (menu Bars/Dynamic Font Size (Zoom driven) – beta
  • New demo files + Tips – redesigned demo files including Tips (available on the release date)

Version 2.1

General availability end of August 2021

  • Milestones
    • New Milestones shapes – line, star, flag, lightning, triangle down, hourglass, „x“, „>“, „<"
    • Now, you can use up to 20 categories of milestones
  • Bug fixing
    • Landing page – shows „ADWISE“ landing page only with empty visual, otherwise blank/white page is shown while loading visual
    • Not correct lenght of time axis (too much blank space on the right side) is fixed
    • Sorting for long text strings and numbers is fixed
    • Correction of the height of bars when Today and/or Target line are shown (no more shrinking)

Version 2.0

General availability on April 7th 2021

IMPORTANT NOTICE: With this version, you will have to remap your Description and Value fields in the visual (if you use them) after visual update. Remapping means only to drag these fields from your source data to corresponding boxes in Fields pane in Power BI.

  • Completely new zoom/scroll functionality (new formatting menu Zooming)
    • Zoom – now you can zoom your RoadMap to see more details or fit larger datasets – you can set the zoom by button (+/-) in the bottom left corner or by percentage – both horizontally a vertically
    • Scrolling – once your RoadMap does not fit into visual area (e.g. when zooming), scroll bars appear
    • Fixed height of rows – you can set up fixed height of rows, thus the rows remains the same when you filtering, adding more data etc.
    • When zoom/scroll is not desired for end users, you can switch it off
    • Zoom/scroll items (+/- button and scroll bars) automatically disappears after 1 second when mouse off the visual area
  • Progress bars (new menu item in Bars formatting menu)
    • You can show progress within the bar with the same, but lighter (saturated) color
    • Color saturation (for the „progress“ part of the bar) can be changed in the same menu (from 0.1 – 0.9)
    • Progress is based on the Value field (this field has to be mapped to show progress)
  • Look & feel changes
    • Bars – different types of edges/corners (square or rounded) to better suit your graphical preference
    • Left axis – right/left label alignment and text wrapping
    • Standard Power BI font added – Segoe UI
  • Other
    • New sample files with Hints & Tips how to work with visual
    • Blank screen appears when visual filtered with no data to show (instead of the standard landing page)
    • Sorting field can be used with larger sorting strings (up to 100 characters)
  • Bug fixing
    • Blank space no longer appearing above and under the visual when large dataset mapped

Version 1.5.1

  • Bug fixing
    • Coloring by Group for Axis Y
    • Filtering outwards to other visuals (on page)

Version 1.5.0

  • Only 3 fields needed to render visual
    • Now you can map only Axis Y, StartDate and EndDate to render visual – all other fields are optional
  • Basic and Pro features
    • If Basic features are used, the visual is rendered without watermark
    • Pro features – using fields Group / Category / Value / Sorting
  • Groups
    • Separate formatting section, Groups are now independent from Axis Y
    • Can be hidden / shown independently of the Y Axis
    • New formatting options in this section – fonts, sizes, text orientation (horizontal/vertical) and text wrapping
    • Group labels text color options – fiexd color, or can be colored by groups
  • Left Axis
    • Can be hidden / shown independently of the groups
    • Coloring by Group color possibility or individual coloring option for Axis Y labels
  • Bars
    • New option for Default Bars‘ color (applied to all Bars, if do not have Category defined)
    • Fixed labels and description text flowing out of the bar area
  • Milestones
    • New option for Default Milestones’ color, size and shape (applied to all Milestones, when Category field is not defined or mapped)
    • New formatting option to change the size of the milestone – you can adjust the size of milestones – independently by Category
    • When Milestones text/labels overlap you can opt for hide text or show only last one
    • Milestones are now with white border – to see them all when shapes are overlapping
    • Up to 10 milestone categories are now supported
    • Coloring by Groups possibility
    • Added new milestone shape „+“
    • Milestones can be shown without text, only shapes – new setting – show text on/off
  • Tooltips
      Original “Tooltip” was renamed to “Info Panel” (see bellow)
    • Added standard Power BI functionality for standard tooltip and individual page tooltips
    • Tooltip shows values of all mapped data fields of the Bar or Milestone over which mouse is pointed, unmapped fields are hidden
  • Labels
    • New separate formatting section allows to set labels for fields shown in tooltips and Info panel (fields Groups, Axis Y etc. to suit your needs (e.g. Axis Y = „Projects“ or Axis Y = „Campaigns“ or you can localize the names of fields)
  • Info panel (former Tooltip)
    • Info panel under the RoadMap shows all fields from RoadMap for selected Bar or Milestone
    • Info panel field labels are defined in Labels section
  • Bug fixing
    • Filtering – when filtering, report colors (e.g. of categories etc.) remain the same
    • Adding new data – categories color remains the same
    • Overflowing description text in a bar – when description text in bar is shown and it is overflowing from a bar, the overflowing lines are hidden
    • Description text in a bar position – when bar’s label should be hidden due to overflow („on text overflow“ is set to „hide“), the description text (if shown) is positioned properly within the bar

Version 1.0.0

  • Initial version

 

Další informace

Základní informace a cenové plány | FAQ | Obchodní a licenční podmínky | Ochrana osobních údajů