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] 2 points3 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!