Writing measure to show multiple visuals on the same chart with one slicer
Hello, I am sorry to keep posting looking for a solution on this. I am trying to write a measure. I have tried multiple methods but cant get anything to work. I would assume having two different measures on the same visual would work. I have two tables (Table1 and Table2). My goal is to use one slicer and show multiple visuals from the same table on the same chart. For example, if a month is selected, I want to show data (filtered with different conditions) for that month, and the month most recent to the selected month. Column 'Table1'[Month] is linked to Column 'Table2'[Month] with a one to many relationship (Table2-one, Table1-many). Then I have a slicer that uses column 'Table2'[Month]. The visual for my current month works, but now I am trying the add the data to the same visual for its previous month. For the previous month, If the user selects a month with the slicer, I want to save the [Previous Month] associated in Table2 column as text. So if 24-Jun is selected, I want to save "24-May" as text. Then I want to filter and count the number of rows in Table1 where [Month End] = the saved text & Type = "Task". So in this example, I would count the number of rows in Table1 where Table1[Month End] = "24-May" & Type = "Task", and this would return 1. Table1 ID Status Date Rank Previous Status Month Type Group Previous Month A Normal 3 No previous 24-Mar Task <0 No previous B Normal 3 No previous 24-Mar Task 1 to 5 No previous C Not Normal 3 No previous 24-Mar Task 1 to 5 No previous D Not Normal 3 No Previous 24-Mar Not Task 11 to 15 No previous A Not Normal 2 Normal 24-May Task 6 to 10 24-Mar B Normal 2 Normal 24-May Not Task 6 to 10 24-Mar C Normal 2 Not Normal 24-May Not Task 6 to 10 24-Mar D Not Normal 2 Not Normal 24-May Task 6 to 10 24-Mar A Not Normal 1 Not Normal 24-Jun Task 1 to 5 24-May B Not Normal 1 Normal 24-Jun Task <0 24-May D Normal 1 Normal 24-Jun Task <0 24-May E Normal 1 24-Jun Task 1 to 5 24-May Table2 Date Rank Month Next Date Rank Previous Month 3 24-Mar 4 2 24-May 3 24-Mar 1 24-Jun 2 24-May Sample of visual I'm trying to create: Measure that doesn't work for previous month: (I keep getting blank when selecting a current month) VAR SelectedMonth = SELECTEDVALUE('Table2'[Month]) VAR PreviousMonth1 = CALCULATE( MAX('Table2'[Previous Month]), FILTER( ALL('Table2'), 'Table2'[Month] = SelectedMonth ) ) VAR CountRows1 = CALCULATETABLE( 'Table1', FILTER( ALLSELECTED('Table1'), 'Table1'[Month] = PreviousMonth1 && 'Table1'[Type] = "Task" ) ) RETURN COUNTROWS(CountRows1) Measure works for selected month: VAR SelectedMonth = CALCULATE( MAX('Table1'[Date Rank]), FILTER( ALL('Table1'), 'Table1'[Month] = SELECTEDVALUE('Table2'[Month]) ) ) VAR _tablecalculation = CALCULATETABLE( 'Table1', ALLSELECTED('Table2'), 'Table1'[Date Rank] = SelectedMonth, 'Table1'[Status] = "Not Normal", 'Table1'[Previous Status] = "Not Normal", 'Table1'[Type] = "Task" ) RETURN COUNTROWS(_tablecalculation) Any help in the right direction is definetly appreciated!
How to prevent the measure result splitting over all the departments in a clustered column chart?
Hi guys, I have created a clusterd column chart with the departments on the Axis. The value of the clusterd column chart is a measure where I calculate the count of unique values in the column "Versies.Id" of the table "MKA", but only for those rows where the column "VullingProductTbbRubricering hh" is not blank. The measure is: ALLE-GII = CALCULATE( DISTINCTCOUNT(MKA[Versies.Id]), MKA[VullingProductTbbRubricering hh] <> BLANK() ) What I want now is that the total result of the measure "ALLE-GII" will be added only to one department "GII" and will not split over alle the different department. How can I do that? See picture below for how the column chart is looking right now.
How to create clustered column chart containing think cells
Hello, I am trying to create a visual that should look like the below print screen, however I am not able to find a visual that shows similar outcome. The visual should show the sales of the 5 products (A-E) for 2021 & 2022 and the thinkcell should include the % vs. PY. I have created the DAX measures to calculate seperately the 3 values (2021 sales, 2022 sales & %, however I cannot find any visual with the above outcome. Do you have any idea if it`s possible in PowerBI to have a similar visual? Any help would be highly appreciated.
YTD on the end of clusterd column chart (one chart)
Hello, team. I would like to know how can I put the YTD on the same chart of the other values. I tried following these guidelines but it didn't work: Solved: Re: Weekly graph data and YTD data in one chart - Microsoft Power BI Community Thank you in advance for your help 🙂
