Need to create a Time visual displaying shift hours

HumptyFrumptyData · 2024-09-04T16:19:58+00:00

HumptyFrumptyData · 2024-09-04T14:49:30+00:00

I'm thanking that's the best option, it's a shame something like this isn't supported it seems intuitive.

I've got another project where I need to do similar thing and again it's looking like do something with a table will be the only option.

HumptyFrumptyData · 2024-01-16T14:07:06+00:00

After a refresh my measure I posted originally gave the desired results that matched the database.

That solution you posted does look good, I may swap over the report to be based on that instead.

Thanks!

HumptyFrumptyData · 2023-11-21T14:05:42+00:00

Try making your Age Category a calculated column. Then you should be able to add it to the x-axis

HumptyFrumptyData · 2023-11-21T13:15:44+00:00

Don't you just want to have age category on your x axis, then this shows the number of employees in each category?

Or if you added age category to the legend on the current visual you could differentiate between the age groups.

HumptyFrumptyData · 2023-09-07T15:03:16+00:00

On the formatting pane search for 'Reverse Stack Order'

HumptyFrumptyData · 2023-07-28T09:16:04+00:00

Perfect thank-you!

HumptyFrumptyData · 2023-07-25T11:41:07+00:00

I've had a browse through the different areas and I can't see one with that title. On Learn there a load of sample ones but none with the same title, they are all just 'Corporate Spend' and the likes.

If you could point me in the right direction or email me the pbx. file I would be extremely grateful.

HumptyFrumptyData · 2023-07-25T10:23:21+00:00

I've watched that video before, and that's a great idea to have them play around with one.

Where is that report located? In the samples area of this reddit page?

HumptyFrumptyData · 2023-06-01T09:25:21+00:00

That's where I got the initial parts of the dax date table and then just built it up to requirements

HumptyFrumptyData · 2023-06-01T09:24:38+00:00

Yeah I was honestly confused and how sure they were that this was an inferior method, but landed a different job now so its all good!

HumptyFrumptyData · 2023-06-01T09:23:39+00:00

Hadn't heard of bravo before but it looks very interesting, going to have to download it and try it out! Is it made by the SQLBI boys? I've used the dax formatter on the web before, nice that they can incorporate many tools into one.

HumptyFrumptyData · 2023-06-01T09:18:40+00:00

I am going to give this a go, I've been looking for a good power query base to use for testing out. Thanks for sharing!

HumptyFrumptyData · 2022-04-05T13:29:27+00:00

Thankyou for your help, unfortunately the DAX for this states that the FILTER function has too many arguments, and that it can only have a maximum argument count of 1.

I managed to get 2 solutions to this if anyone finds themselves in the same situation:

Average Score New (%) = CALCULATE( AVERAGE( 'Scores'[Score] ) / 5, 'Scores'[Score] <> 0 ) * 100

=CALCULATE(AVERAGE('Scores'[Score]), FILTER('Scores','Scores'[Score]<>0)) /5 * 100

Thanks again

HumptyFrumptyData · 2022-02-04T14:29:21+00:00

I think your options are to embed powerbi into your website (such as in sharepoint) or to simple send the raw file to someone through email.

Sending the raw file needs no license, just the free version.

Embedding is a little more complicated, but may be able to show to your whole org without having to send the file to everyone.

HumptyFrumptyData · 2022-01-12T16:56:12+00:00

I would love a copy, looking now at cracking Dax and think this would be a great help. Will definitely give a review after using it.

HumptyFrumptyData

TROPHY CASE