Dax Formula for Graph Multiple Series with Variables from User Inputs
I have a report user that wants me to create a graph where the data points are based on inputs he can enter (using slicers pick a product, a date range, a system, etc. There are at least six different entries in total) and then put a second set on the same chart. The example in excel is he creates series based on different inputted information and then creates a graph that compares the two. Is there a way to do this with dax so it's based on user inputs through slicers but they don't have to create the graph? Here is his example that he creates in excel for his reporting. The batches are not defined in our system, the engineers and production just know based on date range which items belong in which batch, so they aren't something I can control or easily define. The user (engineers/production team) need to be able to define each series for the graph in the power bi report.
Sorting Matrix Data Based on Slicer Selection
Hi Everyone, I want to sort the data in a matrix in a specific order. When I select a value in the slicer. Below is the raw data: The matrix visual contains Product and Value [Measure]. Raw Data Slicer The order in which the products need to be sorted depends on the year value selected in the slicer. Raw Data : Table Product Year Value P3 2023 100 P2 2023 200 P1 2023 300 P8 2023 40 P6 2023 100 P1 2024 200 P3 2024 300 P2 2024 40 P14 2024 100 P12 2024 200 slicer : Year 2023 2024 Required order, when we click on slicer : Order Required 2023 2024 Order order P1 P1 P2 P2 P3 P3 P6 P12 P8 P14
I need a DAX measure to calculate an average of scores by selected agents over selected months
I have been trying to use the following measure to create a column in my Visual Table to give me the average of each agent for a group of selected months. If I change the slicer for different months it gives me the average for each month instead of averaging them together. Can you help?: Average Agent Score for Months = CALCULATE( average(TestScores[Score]) ,FILTER(ALL(TestScores), TestScores[Agent] IN VALUES(TestScores[Agent])) ,FILTER(ALL(TestScores), TestScores[Month] IN VALUES(TestScores[Month])) ) Here is what I get: Example: For Barney, I expect to see the average of 39 ((39+48+34)/3) in all three places. and if I change the months, I expect to see the average recalculated for the new group of months. I am using a test table of data: Month Agent Score Team JAN Bill 32 Barney FEB Bill 32 Barney MAR Bill 37 Barney APR Bill 33 Barney MAY Bill 48 Barney JUN Bill 40 Barney JUL Bill 37 Barney AUG Bill 45 Barney JAN Mary 43 Barney FEB Mary 32 Barney MAR Mary 50 Barney APR Mary 43 Barney MAY Mary 46 Barney JUN Mary 50 Barney JUL Mary 46 Barney AUG Mary 50 Barney JAN Raval 46 Mavis FEB Raval 41 Mavis MAR Raval 43 Mavis APR Raval 43 Mavis MAY Raval 37 Mavis JUN Raval 39 Mavis JUL Raval 35 Mavis AUG Raval 30 Mavis JAN Luego 30 Mavis FEB Luego 33 Mavis MAR Luego 33 Mavis APR Luego 50 Mavis MAY Luego 41 Mavis JUN Luego 34 Mavis JUL Luego 36 Mavis AUG Luego 38 MavisHow to set Default filter for Matrix or Table
Hi everyone, I want a matrix to show values for a particular filter, L1, from KPI Level by default. Note: I will use KPI Level as a slicer. When I click on the L2 slicer, the table should display L2 data. For L3 selection, it should show L3 data, and for L1, it should show L1 data. If no filters from the KPI Level slicer are selected, the table should display only L1 data by default. The table needs to include the following columns: - KPI Level - Region - Category - Target - Actual Below is the data view of the dataset: ChatGPT data prompt: https://chatgpt.com/share/b2a755d3-e928-4817-80ef-a643de3c6bf0 Dax formula i used: Defualt_Target = Var _a = SELECTEDVALUE(Data[KPI Level], "L1") Var _b = CALCULATE(sum(Data[Target]), FILTER(Data, Data[KPI Level]= _a )) RETURN _b I am not able to acheive the result what i wanted
How to exclude a parameter filter/Name from one of my charts
Hi all, Power BI question I have situation where I have a pararameter set up param1 = { Name,nameof('dictionary'[Name]),0), { station,nameof('dictionary'[station]),1), { title,nameof('dictionary'[title),2) The parameter selection works and filter's as they should, however for the stacked column chart, I would like the Name parameter not to appear on the stacked bar chart and rather default to another default view on the bar chart. The reason for this when I click the name selection, I have over 300 names and that is an overwhelming look on the x-axis and has no use visualing for what i am trying to achieve. so below is a recreation of what i am workin on in Power BI. So when I select name on my drop down (powered by the parameter). I would like only the table to be affected by the change and the chart to ignore showing name as the x - axis dimension. so here if i selected name the table would list all the columns, but the chart would default and or stay in a view that shows thw count of stations by title. this is the view when station or Title is selected. Name does not appear on the table.
