powerbi

Hi Team, I'm stuck with how to replace text in PowerBI. I got one column which contains multiple names with special chars and would like to get rid of all those and just keep it as names separated with ";". Is there an easy way to achieve this? example cell A2 Bage Khiu <57697099.b2wg>;Jonas...

Hi, A question for Power BI users. Have tried searching for this question, but no luck; and I hope I can explain it properly. I have data that contains a parent code, and a city, with Yes and No answers. I have created one measure that gives the % of Yes to No. I have created another...

So i got some rough data from an SQL, it is in JSON and it's poorly formatted. I've somehow managed to format it almost how i want it, now i'm just limited by my skills and i can't seem to find anyone with a similar issue. I've tried several things, split by list, group, transposing you name it...

1- To improve the Quick Insights supplied to your dataset’s users, what should you do? (Select all that apply.) i. Hide columns that don't return useful results. ii. Display only one date column. iii. Hide redundant columns (e.g., keep StateName, hide StateAbbreviation). iv. Rename columns...

I have been able to connect data to excel using publically available APIs and Power Query. Stuff like data from this page and an API like the equivalent downloads for UTLA API. I get data from a Power BI dashboard but they don't have a publically available API like the data above but copying...

Hi I wanna create a workbook containing all the macros I am likely to need. I will have a table already downloaded and the first macro I wanna create involves adding additional columns from AU with these headings Postcode ID_for_db Firstname_for_db Lastname_for_db Postcode_for_db...

I am building a dashboard to show progress of employees through a long-term training program. I am trying to create a measure to track progress against time-based expectations, and I'm struggling with the DAX logic. The model I have is a variation on a star schema. The central table is a record...

Hi so I have automated huge parts of my job and I wanna work hard to work less. I have daily tasks and I hope I can automate it so that I can do more important things with my time. So I am given a link to a Power BI dataset and I have bookmarked the relevant pages and I want to see if it's...

Hello, I am trying to attach several columns in one table to one column in another. Here on the "Accessory" table, we can have up to 3 devices, in the three columns. Device Type Device Type2 Device Type3 IPHONE 6S+ IPHONE 7+ IPHONE 8+ IPHONE 12 IPHONE 12PRO IPHONE 12 IPHONE 12PRO...

Hello I am trying to return a list of products as my values for whatever time period I have selected, that makes up the top 50% of volume. I want the ability to be able to show multiple weeks on a visual but be able to see by item what's driving sales each week and how often they're the top...

Hi all, I wonder what I am doing wrong or maybe I have missed something. When I filter on the 164 Due more than 3 Weeks the Within Timescale visual updates (brilliant). If I then select the 1 False the Visual updates as well the the one to the left (image below). This then has a knock on...

I have a power BI Dashboard that drills down by organization and I have 2 DAX Measures that I need to change based on Organization. I was able to set a filter on the count measure but I can't get the Sum measure to filter. Can you tell me what I am doing wrong? YTD PVA Target = CALCULATE (...

Hello, I am new in this forum and I want to participate to find solutions for any user problems. I am an expert in MS Excel, but just a starter in PowerBI. Right now I am working on a dashboard for price reductions and I want to make a sum of different types fo price reductions. My table looks...

Hi Experts, Please can you suggest if power BI is a right tool for this: Integrate data from various sources, match addresses (Removing all spaces, characters and comparing and highlighting the differences) Add columns where relevant and update the sheet based on different sources for each...

Hi, Our daily sales data stored in Excel under the "sales" folder. I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales" based on the date. I would like to create a new table to achieve my result - What are the item are newly added (unique) from Monday last week...

I tried to follow the article to migrate power bi collection to power bi embedded However, I got stuck very quickly. For example, in our app, we use these nuget packages (Microsoft.PowerBI.Api and powerbi.core), and these are some of our usages...

Hi guys. I have a report that I display in PowerBI. There are numerous measures. My issue is that some of the measures should be averaged, some should be summed. Is there any way that I can control if a measure is a "Sum of" or"Average of" based on who is selected in the filter? The...

Hello, I have pulled in data from SharePoint to make my PowerPivot. When I send the reports to others and they go to Data-Refresh, they get the following error message: Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException I found this Work-around : go to Get Data/ Data Source...

Hi all, Here's what I have done: - I have merged 2 queries/tables - to create, let's call it, Query A - then duplicated Query A, selected Category column and then "deleted other columns" so as to create a "Category" lookup query/table. - I then deleted duplicates in this Category table. -...

Hello there, I am querying a remote PB server by doing a POST to its REST url (something like https://XYZ/public/reports/querydata). The query is contained in a JSON file which looks like this { "queries" : [ { "ApplicationContext" : { "Sources" : [ {...