Struggling to create Measure :( Please help!!
Hi community, I am really struggling to create a measure that basically shows the StatusID every day in a date calendar until it changes. My dataset has some IDs with different StatusID that changes along the time. The idea is to create a gantt chart where i can track along a month how often each ID changes its status. I created a dimension calendar table to have all the dates, as my fact table doesn't have all the dates. Each row in my Fact table will have ID, StatusID and Date. When an ID changes the status it will create a new row with a different StatusID an a new Date. I attach a picture of how it looks right now: - I have a date slicer on top of this matrix filtering the last 7 days. - The matrix has ID as rows, Date from the dimension Calendar table as columns and StatusID as values. - My objective is to create a measure that shows the max StatusID for each day of the dimension Calendar table For example, the first rows of the table below will show 1s until the 25th of October where the StatusID will change to 2 and it will show a 2 until the 31st of October. I hope I explain well my self, anyway I can clarify it. Thanks so much M
Is possible to show One Metric with details and rest simple by using Dax functions ?
Hello, I need to show measures dynamically in Grid or Matrix visual, I have a set of data with over 20+ Metrics precalculate in SQL. Those measures come from different Fact tables and it is with tabular data. Based on from audience request I am looking to see if can be possible to do this: Using Dynamic Slicer show in the front one measure with some extra analisis (frame in blue) then keep showing the rest of the other measures simple as thier value come. I am be able to change dynamically the blue frame but I wondering if it is possible to show the rest of the measures. I am looking to do it in DAX but let please know if this can be done under Dax or under Query Editor but my preference is under dax. For example from the slicer metric selection I choose metric A. This one show all the details related variance, vol, vol% , impact, etc. but then rest of the metrics not select show next the metric selected it. Then if Metric B is select show the details and rest of the metrics simple.(metric b is back wit rest of the metrics) If the Metric c is select the that change in the blue frame and now metric B and metric A are back wit the rest of the metrics Apprecite your advice and guide.
Need 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
