I have an interesting power query problem here where my data is escalating downward as shown in this clip. How do I get the non-null values to be in one column?

I'm using pro account to publish my reports on Services. but they are all too slow of loading until complete. I created 5-7 pages, with 4 cards (new) with navigator buttons, 1 tables and 5 visual charts for each page.

Took a PL-300 prep course on Udemy and spread it throughout this week. Wanting to get more practice for the test before taking it. Also my current role is more on the business side and not on the data side, any suggestions/tips/resources to continue practicing my PowerBI prowess after taking the test. Cheers!

This Udemy course specifically:

https://www.udemy.com/share/106kOs3@7NLsQqVcQH_pQRXGjBmyh7u4sp-x_-HYxH0VLHOejedR3yUrG-Sq3WCA0pmn1Qi9/

I have lost several position offers because I have no knowledge of SQL server regardless of my experience with powerbi, is there any paid training, channel, book, any suggestion you have for me to learn this fast, at least the basics? In my current company as in previous I’m not elegible to have access to SQL, so O have to practice at home.

Any advice is appreciated.

Hello! I have data and different columns based on the structure of the data. I have columns: city, product and amount sold. How can I make a table which shows € of products sold by city?

anyone has recommendation for sourcing FREE PBI templates? Of course there is google search but I am more interesting for free templates that you are using in your daily work.

View Poll

I am a Windows user in a company where most people use Macs. I am interested to find out how I can share interactive PBI reports with my colleagues so that they can see and interact with the dashboards. I know one option would be to pay for Pro membership but I find it really expensive to pay £20 per user? Is there any workaround that? Eg in Window based users, I would have saved the pbix file in a sharepojnt and they can open on PBI desktop to interact with it.

View Poll

I have table A as below. I need to find all related customers and make them in a grouo as in Table B.

I just recently come across IBCS reporting and I have to say I really want to introduce this in my company hoping they will support it. It's hard to find any reviews about it so here I am.

Anyone here can share any success on implementing this in your company? I just proposed to purchase the Zebra BI license in PowerBI since custom svg visuals are time consuming.

Also if IBCS Analyst certification is recommended?

Thanks in advance!

https://preview.redd.it/3n2nn0x13hyd1.png?width=481&format=png&auto=webp&s=5bc410ea5591d5af21cbf0a0856a73ad3fea11d9

PowerBI automatically formats "RANK" (a calculated column) based on RANK values, but as soon as I try to change the conditional formatting options, it requires a column of my dataset. How to work around this?

Hi All,

I have a SQL query that I'm running against a SQL 2016 server. This dataflow has been humming along nicely until I was provided a need that required me to extend the query with some extra columns.

I was able to update the query with the extra columns with minimal effort, but it required me to use a temporary table #actualCloseDates and fold it back on the main query. My temp table needs now to just change from a MAX() function to a MIN() function. Now... I can't get it to work:

• Changing the query won't finish evaluating the preview
• saving won't run through its schema checks and things
• refreshes fail (I was able to get it to save once or twice through what feels like a "glitch")
  • Note also, I got it to save a couple times and the table isn't available to pull into PBI reports afterward

Here's my question, is there any way I can tweak the settings of the dataflow to get it to evaluate on a top 1000 query (or otherwise subset of the data) and then the refresh bring in the rest of the data?

Are there any other suggestions? - I "feel" like the power bi pro offering is getting worse and worse with more of my dataflows failing to refresh even though they were working fine a while ago

• Reboot my gateway?
• Update/Upgrade my gateway?
• Tweak the dataflow settings? (which ones and where)
• anything else?

TIA everyone in advance for your ideas and suggestions!

Hey guys, I am having some trouble ordering the stacked colum chart So i need the order of these stacks to be consistent throughout all the years How can i order it in a way that it all stacks across the years are parallel to each other

Please point me to the direction where I will learn how to analyse higher Education Data using Power BI, power query and DAX.

Currently testing a FT1 Fabric trial capacity which I think is an F64. Is this too close to limit?

Hi Everyone,

I am Experienced PowerBi Developer with a total 5 years of experience into end to end Data Analytics. Along with I have Java Backend knowledge but not a hands-on experience. I am looking for Job outside India, but don't know how to apply or where to start from.

If anyone helps me out will guide me.

I have two dates (two separate columns) in a table.

Start Date and End Date do you have suggestion on what visual I can use so that I can combine them in one visual with one picker being start date and the other picker the end date.

I tried several visuals in PBI but nothing seems to work.

Hey, here is a question regarding bi-directional filter. 

https://preview.redd.it/qek7puxfrfyd1.png?width=917&format=png&auto=webp&s=b5f00d92f0769518c35983b427e8787de7abc6cf

To enable bi - directional filtering and row-level security for the many-to-many relationship in above data model, we must first:

A. define the relationship as active

B. delete the many-to-one relationship

C. change cross filter direction

My answer is B since I think there is only one active relationship between two model tables. But I take a test and find it can be existed two active relationships and set cross filter as both, and the filter work normally in the visual.

https://preview.redd.it/ei9sf9xlrfyd1.png?width=1067&format=png&auto=webp&s=9935e6713fda4a65b0cec7b3f9385bdd8c2e73d0

So I am confused about the question. Anyone can help me what is the exact answer and why? Thanks.  

Hi, I heard that the PL-300 certification is mainly intended for data analysts. I work in supply chain, where we deal with a lot of different data, mostly semi-structured and unstructured. Unfortunately, most of our data comes from different spreadsheets, as our software is outdated.

I'm wondering if the PL-300 would be useful for my field?

My goal is to make our data more structured and organized for an OPERATIONAL level, starting with Excel to clean and make it interactive for my colleagues(they struggle to do anything in excel so i need to keep it easy for them to use), then using Power Query for bulk cleaning and loading, and finally Power Pivot to create visualizations.

Since this is an extensives certification, it feels like I should focus on just part of it. its not my field since i did everything with random youtube video when i had a problem/could formulate my needs.

Which sections would you recommend as the most relevant for my needs?

or would you recommande something else ?
thanks a lot for your answer !

I have been stuck on this for a bit.

Here is a description of the data.
Employee table:
ConsultantID, actual_date_worked, rate, hours

Job Table:
ConsultantID, start_date, End_date

This is Many-to-Many job between the tables. I can put a bridge in with distinct ConsultantID's if needed. A consultant can log multiple entries at multiple rates for a single day and a consultant can work on multiple jobs on a day.

Basically, a consultant can work on multiple project at any time. So I need to be able to count how many distinct consultants are on a project for a given day.

_EmpCount = 
CALCULATE ( 
    FILTER ( 
        employee,        
        employee[actual_date_worked] <= RELATED(Job[end_date]) &&
        employee[actual_date_worked] >= RELATED(Job[start_date])
    ),   
    distinct(employee[people_id])
)

Filter is complaining about the relationship and that it cannot be used in this context. I must be missing something simple. Thanks in advance!

Hi, I have created a powerbi composite model report by connecting with multiple powerbi semantic model (remote source/data). I need to apply RLS for department. Can anyone help me with it?

I have a calendar table I am using that has 'week of' (start of each week). How can I limit the slicer tile objects to be only those that are for the current week and the next couple of months so that I don't see years of choices in the slicer. I hope that makes sense.

Hi everyone, I'm a Toronto-based technical recruiter seeking a Senior Power BI Developer for one of my risk & financial advisory consulting clients. Must have 10+ years of experience in Power BI, ETL & Azure. Feel free to let me know if you're interested - send me your resume and we can chat about the company/hourly rate.

I'm a Software Engineer with some ideas for improving the user experience of custom visuals. Although I don’t have extensive hands-on experience using these visuals, I’d love to hear your thoughts - what do you like or dislike about the visuals currently available on AppSource?

To create realistic images of selected cars fitted with ARS Alpha and ARS Beta rim models in black and silver for marketing use.

The images should emphasize the quality and style of ARS rims, appealing to automotive enthusiasts.

- Place ARS Alpha and ARS Beta rims in both black and silver realistic onto different car images 8(eg. sports cars, normal cars, oldtimer,...) The png of the rims are attached.
- Ensure the images are realistic and high-quality.
- Images are intended for use on website, social media, and print advertising.

Hi Folks, odd issue I'm running into here:

MEASURE =
VAR Variable1 = VALUES(Table1[Column1])
VAR Variable2 = VALUES(Table2[Column1])
VAR ConditionalVariable =
IF(
Condition = TRUE(),
Variable1, Variable2
)
RETURN

Calculate(
Something,
FILTER(
Table3,
Table3[Column] in ConditionalVariable
)

I get the error "The function expects a table for argument " but a string or numeric expression was used"

If I use this then there's no error, is the conditional turning the table variable into a string?

Calculate(
Something,
FILTER(
Table3,
Table[Column] in Variable1 or Variable2
)

Thanks in advance!

Hello all,I know you probably have had so many comparisons like this,but I really need help deciding which one to go for. I'm an absolute beginner when it comes to Power BI never used it.I recently got my IBM Data Analyst certificate and I wish to learn Power BI and take the PL-300.

Edit: Thanks to all those who commented.I've signed up to Maven Analytics!

Hey all!

Recently, I’ve been getting into DAX and working on brushing up my skills. I’d love to have a quick-reference guide with formulas and short descriptions that I can print and keep on my desk for easy access. I could type one up myself, but if anyone has already made a well-designed version they’d be willing to share, I’d really appreciate it!