Відео

This is very interesting, thank you! I replicated it and it worked when testing it in PowerBI Desktop. However, in the PowerBI service the visuals still break. Do you experience the same and do you have a workaround?

Can we download the file somewhere?

Some very interesting techniques

guys your work is wonderful but please provide link to the power bi files. so we can experiment on our projects.

It works like a charm!

Amazing! Thank you so much!

Amazing! Thank you!

Excellent! Thank you!

Otro excelente video, otra forma es hacer la medida ranking con index+rank, saludos desde Chile el País mas largo del mundo con 4.200 km, gracias amigos

Hello, will this solution work, if I have more than one store manager for same dataset??

wow just wow!!!

Thanks Bro

Hi, how can I calculate the amount of rows which is visualized on the Sales table? Countrow is working only with dim_Date slicer, not with the Custom periods slicer. Thank you.

Absolutely amazing. Just what I was looking for and couldn't find anywhere else. Thank you so much.

Finished watching

I love you

is it for one selection only? what if for category i have option for select all or select multiple option?

Please explain the logic in last measure, I didn't get it. You are just trying to add results of two calculate functions instead of applying condition.

Due to duplication, sorting by sort order is not possible

Thank you! 3x ❤❤❤❤😊😊😊😊

The period year column includes a string, so how does the comparison with the year integer from dimdate table

It’s a great video and it has helped me a lot! Just one question - can we make rank ignore null values in a column that is passed as a parameter? Currently I have an additional visual filter that uses sync with a condition that this visual filter is greater than 0, but it doesn’t work as expected with rank function you’ve described (it filters out the value and I get rank 1-9 instead of rank 1-10 as in condition😢)

i can use this when i need to show data for the last 4 period, but if i need to add data that only needed for current period it's pop up in every period do you have solution for that

This is a great topic, thanks for sharing!

My past is working fine but my future is pulling up everything on my rolling calendar how do I fix this problem

Hello, this is just what I was looking for and works perfectly on the matrix visual! I do get some issues when wanting to show this as a line chart and want to include both Month and Year on the X-axis. As soon as I toggle between calendar or fiscal, either the Year or the Month fall off the Line Chart's x-axis. Thoughts on how I can go about this?

is it possible to create like Total Sales as Background Transparent and front shows split by legend. Is it possible in Power BI? Excel we can Create

Hi, GREAT VIDEO AND ABSOLUTLY WHAT i AM CURRENTLY LOOKING FOR NOW!! Problem after watching your video. The second option is not working for me. TIME LINE--2:35 When I tried changing the file name to zip file.. nothing happens. the file does not change to zip file like yours. Help!

No thanks 😂

Hi Can you please share this dataset. I have mailed you yesterday

My problem is that in my version of Power BI, the 'Data Colors' command is not available, so I don't know what alternative to use. Which version of Power BI has this command?

Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer -- evaluation requires a different expression than the -- inner one. For example, when ranking an expression over -- a pre-built lookup table DEFINE VAR SalesLevels = SELECTCOLUMNS ( { 6000000, 3000000, 1500000, 750000, 0 }, "@Limit", [Value] ) EVALUATE ADDCOLUMNS ( VALUES ( Product[Brand] ), "Sales Amount", [Sales Amount], "Level", RANKX ( SalesLevels, [@Limit], [Sales Amount] ) ) ORDER BY [Level] ASC 2. How to do approximate match lookup in powerbi

Very creative, but DAX and audio explanations are too fast to grab and understand. I have to rewind several times to get the concept. Anyway, great video.

can you share the dax code here?

Thank You for the solution video , I have also mailed for this query, But in my scenario only one year is showing, Please tell what to do ?plz reply

Very useful information

Thanks for your video! But I have 1 question: If I have a lot of report in my workspace and I want to monitor all historical status of them, how can I do it? Because I see we input the group_id and dataset_id, with 1 report just has 1 dataset_id

Amazing! really helpful!

I tried this approach but it didn’t work .please help me

😮 Thank you 🙏

Hi .i am getting error...it says the sort can't be done as there are multiple values associated.can u pls help

does this also work on a stacked bar chart?

So stupid that something as simple as this and show N periods in a visual isn’t just an option.

Thanks for the video. Similar to how there is the “forecast” extension to the actuals, it would also be nice to see trend (sounds similar to forecast but in my world, the trend is different. Forecast is human input and can always be much higher). Also an extension or a whole different line for budget. And a way to evaluate the forecast vs budget by + or - 1,2,4 percent

So I have a power bi report user. If this report user clicks refresh, would it be possible to trigger the API to put updated data down to the report?

It isn't streaming dataset it is simple dataflow.

Thank you for your help! I have 1 question: when I got to the very end to check, my month is sorted alphabetically instead of Jan Feb Mar etc. do you know how to fix this?

I was trying to create a similar logic but it did not work, compared to you I did it a filter for the past one year, like if I select this year from a slicer, it was supposed to show previous year : New OPEN requisition = VAR _fromdate= IF ( Selectedvalue('Past/Future'[Past or Future])="Past", MAX(NEWDATET[Year]), Min(NEWDATET[Year]) ) VAR _pastfuturemonthshift= SELECTEDVALUE('Past/Future'[Multiplier])*MAX('No. of year'[No. of year]) VAR _periodshift= DATESINPERIOD(NEWDATET[Year], _fromdate,_pastfuturemonthshift, YEAR) Return Calculate( [Open Requisition], REMOVEFILTERS(LU_Calendar), KEEPFILTERS(_periodshift), USERELATIONSHIP(LU_Calendar[DateValue_DATE], NEWDATET[DateValue_DATE]) )

Super! Thanks!

Sir I have tried Measure formula as I have seen but it doesn't show the sum of the selected column in visualization in Graphical way. It says that Couldn't load data for this visual because MDX model script (3, 36) calculation error in measure. What can I do? Please reply