power bi

Is there a way of putting the date column into a matrix that is not a hierarchy, I can do this using the date column from the fact table, but would prefer to use calendar table as I've gone to the trouble of making it, essentially the left , which uses the calendar table to look a bit more like...

Hi, I have a running total in power bi, one using the date column of 'sales' and the other using the Calendar table, I'd like to use the calendar table but because it has every date I get date repeated where there is no current data, I'd like the matrix on the right to filter down to just...

Hi. Hope someone can tell if this is possible in Power BI. I like to make a map as illustrated (see attached picture) - either as a map or satellite. It´s important that I can see where the green shapes is located (city/roads) Is it possible to make shapes like this in Power BI? I thought...

I'm trying below power query to pull data from WebApi but it's throwing error. It's working fine in Postman. Any help would be appreciated. Thanks Body= [ #"apiKey"= "<ApiKey>" ], webdata = Web.Contents("https://api.website.com/api/Profile/GetAllProfiles"...

Hi, I had a PBi file to which I had added a couple of columns (in pbi) , but wanted to play around with the formula so thought i'd make a copy using power query, I selected 'transform data' but the file opened up as it originally was no added columns, I'd asso created a table which didn't show...

Please help for the code I wrote to download Multiple Stock Prices at once. Ringing for Single Share. However, it is not working for many shares. One Stock working: One_Stock.xlsx dosyasını indir - download Multiple Stock Not working...

Hi Team, I have no idea of how to write a DAX for the below situation. At least a hint would give me the right direction. In the image, the 1st table refers to the data table. It has 2 date columns and 2 text columns In the output, for each row I want it to count the number of records that...

Hello, I want to download the Stock list in one go with a loop when I refresh the page. I want it to download every stock in the stock list to the "combine sheet". ----Combine sheet 1st share "C3", 2. Share "C163" ... I want to download as in the example. ----In the same way, I should...

Hello, I am working with a .csv file produced by a proprietary application that includes 4 different tables all jammed together into a single file. Here is a link to a dummy version of that .csv to highlight how the tables are arranged. The key point is that each table has a different number of...

Hello, I want to download the Stock list in one go with a loop when I refresh the page. I want it to download every stock in the stock list to the "combine sheet". ----Combine sheet 1st share "C3", 2. Share "C163" ... I want to download as in the example. ----In the same way, I should...

Hi, Can someone explain why I can't see a 'values' in the report view visualization area , I have x axis etc. but can't see where to drag the values to ? I've added this as thought it might help, yes I have scrolled down . Richard.

Hi, I've created a date table in power bi, but need to make some alterations in power query, but when I select 'transform' to bring up the power query editor, only the source table for the date table is visible. what am I doing wrong. RD

Hello, Can someone point me in the right direction for applying data bars to a bi matrix, it seems like I've been through every drop down menu ; Grid , Values, etc and I can't see anything, I've looked at one or two things online but they seem to be out of date as the menu's are not the same as...

I would like to create a series of measures that shows my current week's sales by day. Example: 1 measure shows Sunday's sales, 1 measure shows Monday's sales, etc. In order to identify the current week, I have added a field to my date table called 'Week Rank' in combination with the max...

Hello All, I am working on a project and I want to know which one supports a query editor between Power Bi and Tableau? According to a source, Tableau does not support this feature may be and I have no idea about power bi? Can anyone explain to me who supports query editor?

Hi, I am using the gauge visualizations to show the sales versus target for the present day and another one for yesterday. The date is filtered via relative date. However I must wait for 08:00 in the morning for that specific visualization to update to the current local time. This is logical...

Hi Everyone, I am building a report in Power BI that will include upwards of 100 photos. Unfortunately, the image hosting site I'm using (Google Sites) is not working well. Sometimes the photos load, and sometimes they don't. Plus, uploading the photo and copying the link over to Excel is very...

Hello, I've been writing a few measures for power pivot, but am trying to get more familiar with the bi environment, and I don't know if I'm being really sturpid, but how do I look at the syntax for a measure already created in power bi, in pivot I just go to power pivot manage, and there they...

Hi Team, So, I have a power Bi task at hand where I have created a dashboard . Issue is I need to display average of a calculated column by month for eg; I have a column with name CSM readiness CSM readiness = csm1 + csm 2...

Hello All, I am fairly new to Power BI and DAX and I am struggling with getting the below measure to work (I have provided to different version of what I have tried). I am trying to COUNTA the # of items that met certain criteria in two separate columns. Each column that the measure looks at...