power bi desktop

Hi, I know this sounds really dim of me but if I open up power bi, and then use 'get data' I can't see the option to open an actual pbix file? I alway just end up going to the folder it's saved in and opening up that way, what am I missing? Richard.

Hi All, I have a table below for which I need to change the background color for the values using DAX measure in conditional formatting. I have also added the output image with the conditions that I want to apply in the measure. I have already tried the measures that are already mentioned in the...

I have data in the format below (minus the far right column) EmailAddress CourseTitle Complete AllComplete 1@1.com Course1 true false 1@1.com Course2 true false 1@1.com Course3 false false 2@1.com Course1 true true 2@1.com Course2 true true 2@1.com Course3 true true Using DAX...

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...

Hello, I have a problem, I have create a little pop up window where there are two slicers. This pop up window is actionable by clicking on a button using bookmarks. So the user will click on the button that enables to open the pop window after he chooses some informations in the slicers and...

Hello, I am an intern and for my company I created three types of dashboards for three types of clients. The company wants to share them to the clients which are seperated in the three types of clients so they need one type of dashboard adapted with their data. Moreover the company uses AWS, to...

I'm using Power Pivot (and starting with Power BI Desktop) to analyse client activity at work. I'm working offline with periodically exported data (no hope of setting things up on our CRM/a SaaS service since it's run by a HQ team that never gets back to me). What I'd like to do is to ask our...

Hello i'm in need of some expert help with a Matrix, i'm trying to created a matrix where the column heading to the left, then the value to the right for multiple rows. I'm not sure if this is possible with a matrix but looking for any suggestions are greatly appreciated!

Hi, Using sample JSON data I need to build a visual most like screen below. Have you seen something like this or could you advice how can i make it? Green <=9, Yellow >9 and <=10, Orange >10 and <=11, Red >11 and <=12, Black >12

Hi. I have created 3 matrix tables (below). The first sums the KS (this stands for school key stages) per day. The second table is the running 7 days sum of those daily totals. And the third table is that 7 day total/divided by denominator *100000 For some reason the third table doesn't do the...

We're looking to build a simple PBI report that will help us process a lot of data and find interesting combinations of factors/ fields/ columns values. The data view/ tab actually suits our needs very well - we simply use filters on ~10 columns and can find a set of records that require...

Hi, I have created a custom tooltip in PowerBi to show additional data on stacked column chart, however when hovering over the chart (regardless top or bottom bar), it only shows data for the bottom bar. Does anyone know, how do I show data for both bars separately?

The automated totals in the report visual table are incorrect. How do I fix this? Additionally, is there a way that I could substitute the automated totals row with my own measure? Picture of Table

My main purpose is to ensure that we are getting new data each day. I have a PowerBI dashboard that has a table with the following columns: Date, Exposure, Capacity. I would like to add a new measure or quick measure that shows the Difference in Exposure between each day. How would you suggest...

I'm trying to find out how to get the average output value that is specific to a unit, tractor, department, and model, into a measure, and then multiply it by a hard-coded number. The relationship between these factors is seen in the Data Table photo. The average output value changes based off...

Hi, I have below Hours:Minutes:Seconds from Excel file 01-02-2021 33:05:51 01-02-2021 14:50:45 01-02-2021 11:19:14 01-02-2021 11:48:32 01-02-2021 07:58:32 01-02-2021 17:08:31 When showing in Power BI in matrix it returns the following: I don't know why, but I can't select sum...

Hello! I am quite new to Power BI. i would like to know if it is possible to have color conditioning in the line and clustered column chart. For example, when the column chart is below the line, it changes to red, but when it is above the line, it change to green. thanks.

I am NEW to Power BI and DAX. I am trying to write a measure and place it in a matrix that filters a list of customers based upon selected dates within a slicer (a customer must be a customer in ALL dates selected). For example, if I have five customers, and I select the dates 01/01/2020...

Good Evening. Is it possible to create a DAX measure to return projected sales based on projected growth rates? I have the figures in columns Year, Base Forecast and WIF Growth Rate. I want the column WIF Forecast as a measure to return the values under it. The numbers in the rightmost...

Hello Team, I have a individual workbooks (each workbook share 3 sheets with same Sheet name, column names) in a shared folder/Onedrive. Requirement is to prepare the master workbook ( with same sheet name, column name ) with changes made in the individual workbooks should be reflected in the...