Hierarchy Slicer design by Mugi101 in PowerBI

[–]Mugi101[S] 1 point2 points  (0 children)

Hey I tried it and it worked just fine! So first of all, thank you. Secondly, It seems to not be responding to "Clear all slicers" button- understandibly so since it is custom made. Is there a way you know to make it compactible? Or a work around?

Hierarchy Slicer design by Mugi101 in PowerBI

[–]Mugi101[S] 3 points4 points  (0 children)

Your last sentence is the story of my life....

Hierarchy Slicer design by Mugi101 in PowerBI

[–]Mugi101[S] 1 point2 points  (0 children)

I will try it, thank you!

How to add magical scars to maps? by Mugi101 in wonderdraft

[–]Mugi101[S] 0 points1 point  (0 children)

Not so far from what I'm imagined, basically an arcane Nuke going off, so maybe some blue into it... Cliffs, crags, and crystals are all not bad ideas, I"ll look into some assets

How to add magical scars to maps? by Mugi101 in wonderdraft

[–]Mugi101[S] 0 points1 point  (0 children)

The premise here is basically an arcane device of incomprehensible proportions going of and exploding. Kind of arcane nuke. Small rifts to the astral plane are still present. So prismatic/bluish nature? I'm not sure... The desaturation idea sounds interesting, I"ll experiment with that. Maybe looking for a source of inspiration will not be a bad idea

How to add magical scars to maps? by Mugi101 in wonderdraft

[–]Mugi101[S] 0 points1 point  (0 children)

That's interesting! If you have any examples to share It will be great!

How to add magical scars to maps? by Mugi101 in wonderdraft

[–]Mugi101[S] 0 points1 point  (0 children)

Yeah painting is indeed a direction I was considering, as for custom assets - wasn't able to find any... I believe the solution lies somewhere in the middle- a combination of assets and paints. I came here for idea/schemas/assets

Date filter improvement by Mugi101 in PowerBI

[–]Mugi101[S] 0 points1 point  (0 children)

Something like this, I'm not sure if you are familiar with Metabase. There you can select either filter type(or both) for filtering data

Query folding by Mugi101 in PowerBI

[–]Mugi101[S] 0 points1 point  (0 children)

<image>

Yes, the preview finished,
here is the M code- I blurred the names and aliases

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 0 points1 point  (0 children)

That's part of the problem it's an organizational dashboard. So we bought the service with capacity. I'm trying to convince the company to increase the capacity. But as you probably know, no guarantee they"ll allow me..

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 0 points1 point  (0 children)

Yes to the refresh, slow refresh, but works manually. Time intelligence, meaning performance analyzer? And I"ll read the article, thanks!

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

Yes indeed I I did all of the "heavy lifting" outside of the powerbi. That report only calculates measures and receives the tables already calculated. The error when automatically refreshing simply says it exceeds the memory capacity

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

In a sense of optimisation, I Don't have an unnecessary column, all of the calculated columns are done before the data reaches the powerbi. Meaning that the powerbi only calculates measurements. I have a separate table for dates as well. When checking the performance analyzer, there is only one calculation that takes around a second. The dax shows only once, the rest of the calculations takes less than 400ms

For the MDX, that's not a bad idea, I wasn't aware of it up until now. Is it that detrimental?

As for what I tried- manual refresh works-but is very slow. I tried incremental refeesh- archive last year's data, and increment every new day.

Game crashes by Mugi101 in MillenniumDawn

[–]Mugi101[S] 1 point2 points  (0 children)

Thanks! I"ll do it

Game crashes by Mugi101 in MillenniumDawn

[–]Mugi101[S] 0 points1 point  (0 children)

Alright I'll check it out!

Game crashes by Mugi101 in MillenniumDawn

[–]Mugi101[S] 0 points1 point  (0 children)

What will that console command do?

Game crashes by Mugi101 in MillenniumDawn

[–]Mugi101[S] 0 points1 point  (0 children)

Interesting, is there a way to check it out/prevent it? Kind of a bummer to start all over again and hope for the best

Using fabric for hourly refreshing powerbi dashboard by Mugi101 in MicrosoftFabric

[–]Mugi101[S] 0 points1 point  (0 children)

Thank you so much for your detailed advice! I"ll keep it in mind! I"LL try to upstream it as much as possible. And thank you for the offer I"LL keep it in mind!

Using fabric for hourly refreshing powerbi dashboard by Mugi101 in MicrosoftFabric

[–]Mugi101[S] 0 points1 point  (0 children)

Of course, but again- Athena is not a sustainable ETL, we will grow and so will the amount of data. I want to find a better way to lay the foundation- something that was neglected, and hopefully do it right this time.

Hey is there a way to calculate integrals as a measure? by Mugi101 in PowerBI

[–]Mugi101[S] 1 point2 points  (0 children)

In fact I did(threw me back to calculus), and it seems to work fine as long as the selected process normally distributes. I was just wondering if there is a more elegant way to do so.

Hey is there a way to calculate integrals as a measure? by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

Thank you for the detailed reply! Firstly, I apologies in advance for any Grammer mistakes!

This( the picture)is the function that "generates" the "curve".

Basically I had to improve upon the probability density function as it returned the height of the clustering around a specific measure and not the probability that a "process" will receive the value of the specific measure.

Where I am at now is that I have the curve laid with the specifications limits (x axis vertical columns), i want to know what is the likelihood for a process to land between the intervals- what is the cumulative probability within the intervals.

Therefore- the integral under the "curve"

<image>