Visualising Two Non Numeric Columns
Hello , I have three fields Date,Name and Percentage.To show it in a visual. I want to group [Names] with [Percentage] column or [Date] with [Percentage] with the help of DAX . Since there are so many items in Names column and also there are two non numeric columns. That way I dont have to use Names or Date column in the visual as two Non numeric columns cant be used. I dont want to use Legends and Slicers bcoz there are too many Items in Name columns. It would be difficult for analysis. The Left Side side I need in visual.Please help. Please tell if I am thinking correctly.DAX Measure to filter Multiple DataSets in Visuals - Power Bi
Ive been at this a week now with little progress and lot of frustration. I have 2 slicers is my projects which are both shows here in the left corner. When I select a Visual Category, I would like the cooresponding Sales by the related Route code. Example, I click on "A Route Time" and the line in the graph only shows A routes. I select "C Route Efficiency (72%)" and i see only sales for C Routes. Now if i select "Open Pickups", I was to see a sum of all sales (A,B,C, Blank, etc). Would anyone be able to show me the proper DAX functions and structure? [Visual Category} is my table for my slicer Here is a sample [Sales] table that has direct relationship to the table above based on Route. Some route letters will not match example D, E or U. Some will be blank.Displaying "average time" in visuals
Hey all, I have a report that is published daily and I would like to see the "average" of the time it is reported during different periods. Basically I would like to have a time visual with the time the report is sent out on every day, plus a gauge/KPI measure with the average time it is sent out on the selected month. I can't seem to get it working properly. I now have two semi-solutions, but cannot have them in one. I made a measure Average Time = Format( AVERAGE('PRIME'[Time]) ,"HH:MM") This helped me to see the average time that the report is sent out in a table. However, because this is "Time" type data, I can't get it in a visual. What I can get in a visual is a "Decimal hour" data. In Power Query I made an extra column that basically transforms the time into a decimal (Hence, making 10:30:00 into 10.5). This allowed me to put the time in a visual, such as a KPI measure. However, the way it is displayed is a bit ugly, as it shows that the average time the report was sent out is 10.75, rather than 10:45. I tried the Format DAX measure on the "Decimal hour" column, but then I have the same issue again as before that I can't display it in a visual. See below the data: Subject Date Time Hour Minute Hour Decimal Report 06 March 2023 08/03/2023 10:26:21 10 26 10,43333333 Report 03 March 2023 07/03/2023 13:36:20 13 36 13,6 Report 02 March 2023 06/03/2023 11:16:48 11 16 11,26666667 Report 01 March 2023 03/03/2023 09:57:43 9 57 9,95 Report 28 February 2023 02/03/2023 15:42:29 15 42 15,7 Report 27 February 2023 01/03/2023 13:38:48 13 38 13,63333333 Report 24 February 2023 28/02/2023 10:30:04 10 30 10,5 Report 23 February 2023 27/02/2023 09:32:23 9 32 9,53333333 Report 22 February 2023 24/02/2023 13:49:46 13 49 13,81666667 Report 21 February 2023 23/02/2023 10:52:10 10 52 10,86666667 Report 20 February 2023 22/02/2023 14:26:17 14 26 14,43333333 Report 17 February 2023 21/02/2023 11:10:03 11 10 11,16666667 Report 16 February 2023 20/02/2023 12:25:33 12 25 12,41666667 Report 15 February 2023 17/02/2023 14:01:36 14 1 14,01666667 Report 14 February 2023 16/02/2023 16:15:52 16 15 16,25 Report 13 February 2023 15/02/2023 10:53:50 10 53 10,88333333 Report 10 February 2023 14/02/2023 09:32:52 9 32 9,53333333 Report 09 February 2023 13/02/2023 09:38:10 9 38 9,63333333 Report 08 February 2023 10/02/2023 09:31:08 9 31 9,51666667 Report 07 February 2023 09/02/2023 11:58:55 11 58 11,96666667 Report 06 February 2023 08/02/2023 10:42:16 10 42 10,7 Report 03 February 2023 07/02/2023 09:58:36 9 58 9,96666667 Report 02 February 2023 06/02/2023 16:18:20 16 18 16,3 Report 01 February 2023 03/02/2023 10:19:02 10 19 10,31666667 Report 31 January 2023 02/02/2023 14:03:17 14 3 14,05How to categorize or label date on a matrix/table ?
Hello! I want to "categorize" date on a matrix/table, just to clean it up and avoid repeating words in the rows. My matrix/table is this, each row is the value of a measure and I have 2 fact tables, INC_table & REQ_table This is my visual currenly, with the values shown per week. And this is how I would like to have as the visual I'm lost and not sure how can thisw be accomplished, If you have any ideas please send them my way Thanks in advance, Carlos
Forecasting predictions for current year
Hello everyone, Trying to predict sales for current year. Already made measure: prediction (sales/number of days from the beggining of the year*365) - current sales. I want to add this measure to my visuals, but the problem is, that calculations are made for all the older years, and i cant filter out only current year value (maybe it is realationship problem - invoice date -> auto calendar). Idea what i want to do is this: Thank you for help!
Two DAX formulas into visuals: 1)Client Growth Rate 2) Dormant Clients
Hi I need to build two separate visuals and I need help with creating the measures for said visuals. 1) Visual 1: Client Growth Rate. The formula is: instead of Q1/Q2/Q3/Q4 I want to use Years. Available Columns: Net Billed, Bill Issue Date (dd/mm/yyyy). Obviously the legend part is the easiest part. However, I'm not able to achieve the CGR per year. Can someone help please? Visual 2: I need to check for clients with no "activities" within the last 6 months dynamically and count them as "dormant clients" I have a table with activities and dates of each activity but it does not show zeros (i.e. clients with no activities). I have a separate clients table. My theory is I can reference ALL the clients from the clients table and filter out those with no activities within the last 6 months but I'm not sure how to do it. Please help!!!Line and stacked column chart does not filter everything that's need to be filtered
So, we have the separate table "At risk parts"(no relationships with any other table) which the visual should be based on this: And a chart that was requested should look like this (3 distinct count of projects on left axis, 3 at risk parts on right axis): "At risk parts" here is a measure based on other table(s). The problem: - Whenever I filter the dashboard the visual should get filtered, too. It gets, but partly. "Line values" part gets filtered fine (whenever I slice, values change as they supposed to), but the "Column Series" and "Column Values" parts of the visual stay the same. How do I get them filtered, too? Is there any DAX measure to help with? I watched a couple of videos on YouTube but didn't get it thank you!
Staked Bar Visual problem (using measures)
Hi, i have a problem with visuals. I have a table (Desembolsos) wich contains values like this : Cuit Cliente Monto M.N. (Millones) Nro Operación Producto Women Exportadores Proyecto Social 452456255 Fulanito 100 2828 1 N S N 455456455 Perencita 200 38373 1 S S S 987521456 Menganita 300 54675 2 S N S 987265554 Carlitos 400 3736 3 N N N I create two tables (no related to Desembolsos) the contains: YES/NO S N Tipo Exportador Mujeres Proyecto Social Then I used stacked visual to counts distinc operations in "Desembolsos" for "Tipo" when YES or NO. I used this measure: Operaciones_Tipo_PRUEBA = VAR _A= SELECTEDVALUE('Agrup. Varios'[Tipo],"Mujeres") VAR _B= SELECTEDVALUE('Agrup.YES_NO'[YES/NO],"N") VAR _C= SELECTEDVALUE('Agrup.YES_NO'[YES/NO],"S") RETURN IF(_A="Mujeres" && _B="N",CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),VW_BT_Desembolsos[Women]="N"),CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),VW_BT_Desembolsos[Women]="S")) I got result as i spect it, but when i select in the visual the result Yes or No my other visuals don't change according to that, and when i select in my other visuals the stacked change normally. What can it be? My interactions are Ok. Thanks a lot!
