Kristian Strub

My feedback

  1. 142 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    24 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub commented  · 

    Hi there. While I agree that there should be some easy setting to adjust FY settings other than Jan-Dec, if you are already setting up a date table either that you link to your data set or configure using a calculated table, you can do this quite easily on your own, with just a little DAX.

    Here is one I use to create a column reflecting my organizations FY (July-June):

    DateFY = IF(DateKey[DateMonthNumber] > 6, DateKey[CY Year] + 1, DateKey[CY Year])

    After setting up a calculated date dimension table with a Calendar Year column and a month number column, you realign your Fiscal Year, as shown above. If you are working with very large datasets, might be best to configure a date dimension table in another source, and connect to it to save on memory consumption.

    Of course, as calculated column value, you can use it as a filter or use is as your configured Fiscal year, Fiscal quarter, month, and day values in your shared axis of a graph to customize your drill down.

    It's a bit more complicated than it needs to be, and it would be nice to be able to just adjust the native setting in your Power BI Desktop to have your date values reflect your FY FQ needs, but give the above a try. It works well enough for me!

  2. 115 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub supported this idea  · 
  3. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub supported this idea  · 
  4. 74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub supported this idea  · 
  5. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub commented  · 

    Yes! There does not seem to be a work around for this either. I even color filled my charts and graphics on the report, but when you pin as a tile, it doesn't bring over the background color fill. Just the plain white default...

    It will bring over the bar and line colors, and the like, but not the color fill? This would be great to add aesthetic improvements, and as mentioned, company branding.

    Kristian Strub supported this idea  · 
  6. 156 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub supported this idea  · 
  7. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub supported this idea  · 
  8. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Kristian Strub shared this idea  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.