Choose metric based on filter
hello! i am very new to the dashboard thing and i am on my way to create my first dashboard. i am currently trying to present what is the orderbook in the container industry and i currently have a slicer to choose the type of container. I have two columns that present: 1. number of containers (count individual vessels) and another one with capacity (capacity of each vessel). I would like the user to see all the charts based or on capacity or number of vessels, depending on the selection they make (could be sum of vessels or sum of capacity). i have tried to check how to do that but so far i have not been able. is this something that can be done in a dashboard? as i said it is my first time trying it and not very familiar with it so I apologize in advance if it is a silla question. i would appreciate a lot your help! thanks a lot in advance, Lau
How the Filter definition of the metric can affect the final result.
Let's assume that I have the Products table in my model defined like this: ProductID UnitPrice UnitsInStock Discontinued 1 10 50 TRUE 2 15 30 FALSE 3 20 20 TRUE 4 25 10 TRUE 5 5 15 FALSE I have created two metrics : Value1 = CALCULATE ( SUMX ( Products, Products[UnitPrice] * Products[UnitsInStock] ), FILTER ( Products, Products[Discontinued] = TRUE ) ) Value2 = CALCULATE ( SUMX ( Products, Products[UnitPrice] * Products[UnitsInStock] ), Products[Discontinued] = TRUE ) The only difference is the definition of the filter. I have evaluated the results in Power Desktop but I do not see any difference. This leads to my question: How could this definition affect the final result of the metric or when might this occur?
PowerBi Metrics - Tracking in reports
Hi, I was hoping somebody might be able to help. I have created scorecards/metrics pulling data from Jan - Dec 23 and have added them to a PBi report. What I would like to know is how do I get the data to display from the start of the year? Right now on my metric visual it is only showing current month and I cannot see anywhere to change this to show year. Please note I am not working on desktop. Thanks.
Help needed regarding Power BI Metrics - Pulling Historical Data
Hello all, I'm trying to pull in historical data in my scorecard / metric by making a connection to a visual as shown in the picture below. Power BI Scorecard The visual I want to connect to: The visual above is about the percentage of the hours the employer was in a meeting. The measure for this is as follows: [Total hours in meeting]/[Total registered hours] When I connect the metric to the visual, it doesn't pull in the historical data. When I change the input of the visual from Month to Date (Datum), I can pull the historical data. But this way I don't have the desired visual I want to use. (See picture below) This visual shows the measure on daily basis. I need to have this on a monthly basis. Is there a way to pull in the data per month into Power BI Metrics? Is there a way to adjust the measure in such way, it shows [Total hours in meeting]/[Total registered hours] only at the end of each month? With kind regards, LazzaNova
How to Create a customed metrics report or download Microsoft Metrics dataset for a report
Hi Experts, I have access for two Workspace and I have this situation : Workspace A : I have a member access but I can see all reports and download any report like the “ Customed Metrics report”. About this report : I don’t have any Idea how it was created. I explored the visuals and data : It used the Microsoft dataset like any Microsoft Metrics reports : the modification in creating some new visuals or changing some dimensions in visuals and some calculated measures : but no changes allowed in data model. (screenshot about this Customed Metrics Report in workspace A and how can we donload it) Workspace B: (I have Administrator access in this workspace) we have other reports related to other analysis for the company and we want to create a “customed metrics report”. So, I decided to create a simple “metrics report” and Microsoft allow us. I followed this links: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics . I save the reports and after I want to download the report: Not allowed to do this. (screenshot about the Microsoft Metrics Report created by myselft and not allowed to download it) My questions: 1- How to download the dataset for metrics report to create reports on Power BI Desktop to create calculated measures, calculated columns, etc. Can we contact Microsoft Support for this need ? 2 - How to download the Microsoft metrics report from workspace B to modify this report in local and make upload for the modified report. ( @amitchandak , @selimovd , @parry2k , @Greg_Deckler , @arvindsingh802 , @arvindsingh802 , @Pragati11 Anonymous DavidIseminger ) Sparkman and all community of super stars , i need your helps , Thanks) Best regards, AhmadovNeed Help to apply sorting in dynamic created column and rows header
Hey Expert, Here I'm with a challenging part with Power BI. I'm creating a report similar to the tableau. Analysis-Seasonality: Link I've been created development-related work in power bi similar to this tableau dashboard. but unfortunately, in the end, I'm stuck on the dynamic header sorting. I need help to sort the matrix's dynamic column and rows header. Dynamic means based on the slicer selection, column, and rows header get changed. As in the below image. In the above image, I have a dynamic slicer year * week, year * quarter, etc. based on this slicer selection header gets change. Let's say year * week is selected, then the year will be displayed on row header, and week will be on the column header. so help need in, If I click on Year * Week year row header and column header should be in sorted form ascending or descending whatever. Year (2015, 2016, 2017, etc.) in row header & Weeks (w1, w2, w3, and so on) in columns Similarly when users click on other options like Month * Hour from slicer then both row header and column header should be in sorted form like Month (Jan, Feb, Mar, etc.) & Hour (0, 1, 2, 3, 4, 5, etc.). That's thing is not getting sort out by me. Please help how can I sort this matrix. Here is the link of the .pbix file for reference https://www.dropbox.com/s/cjmt597dba3dsf5/HeathCare%20-%20Seasonality%20Analysis.pbix?dl=0 Last thing I also want to hide empty/zero rows or column values for that I have applied greater than zero checks on visual level filters but it's not working. Please help Thanks
Calculate average per month based on status
Hello all. I am struggling with a metric which should be easy, but I do not know why it is not showing the information. I have a table with the connection status of multiple entities. Each row means a connection status per day per entity, as a sample: Entity Code DATE Connection Status 1 11-08-19 A 2 11-08-19 A 3 11-08-19 B 1 11-08-20 A 2 11-08-20 B 1 12-08-20 B 2 12-08-20 C 1 01-09-20 A 2 01-09-20 B 3 01-09-20 C So I have 4 graphs based on the status showing the total amount and compared with other years. As an example, for Status A: Nevertheless now I would like to show it in % of the total that month. So I have created the next metric: Status Average = CALCULATE(COUNTA(ConnectionStatus[EntityCode]),ConnectionStatus[Connection_Status]="STATUS A") / COUNTA(ConnectionStatus[EntityCode]) Nevertheless when applied to the visual is not showing the proper value but this: In top of that, I would love to make one single metric, not one for each Connection_Status, is that possible? I am not being able to use the SELECTEDVALUE function, but I bet because I cannot apply it into the visual itself. I have tried to play with the Average(s) functions but are not working properly for me. Thanks in advance
