Powerbi Issues.

[Anonymous]

Hi,

I have a list of Power BI issues which we encountered during the project execution whether below are the actual limitations in Power BI or there is work around available - 

1. The option of loading the report dynamically with previous day’s date as ‘date value’ in the slicer visual together with the filtered data.
2. The option for users to select ‘from date-time’ and ‘to date-time’ for filtering data by using a date-time slicer. By using a date-time column for the slicer it’s showing only the date values and not the time values.
3. The option of automatically changing ‘to date-time’ based on ‘from date-time’ selection (For example, if ‘from date-time’ is selected as yesterday, then ‘to-date-time’ should automatically change to yesterday’s date).

In case, if the user selects any date in the Start Date/Time slicer, dynamically the “Hours:Minutes” in the Start Date/Time slicer should change to “00:00” and also the date in End Date/Time slicer should get updated with the Start Date/Time slicer’s date value with the “Hours:Minutes” as  “23:59”.

     4. The option of aligning the values vertically in the matrix visual to accommodate more values in the screen.

      5. Customizing the matrix visual by removing scroll bar and using arrows for scrolling left-right.

      6. The option of disabling table visuals during initial page load and enabling based on the value selection in the matrix visual on the same page.

 Please let me know if you need any further information.

Thanks ,

Gopinath Sunduru.

[Anonymous · Accepted solution]

HI @Anonymous ,

#1, You can set up dynamic date filter on query editor side or add a calculate fields to compare row content and current date.

M query formula:

#"Filtered Rows" = Table.SelectRows(#"previous steps", each [Date] >= Date.AddDays(Date.From(DateTime.LocalNow()),-1) and [Date] <= Date.From(DateTime.LocalNow()))

Power BI Tutorial: Dynamically Filter By Today’s Date

#2, Current power bi slicer not support to analysis time value, if you want to filter by datetime, I'd like to suggest you to setup date time filter on filter fields with advanced mode.

#3, Nope, you can't use slicer to dynamic modify other slicers selection.

#4, Maybe you can try to use 'show as row' option to display more records:

#5,6. Power bi not support to custom on these part.

Regards,

Xiaoxin Sheng