create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
Visual Filter TopN bug? - Only show first record in a visual based on a column
I have a table visual with a column 'names'. I have a second visual as a progress bar chart which should only show a measure for one person at a time: If no name is selected the first name from the table list (ordered asc by name) or the name that is selected from the table. I have tried to achive this by using the visual filter funtion TopN and filter 1 by name, but it always shows the measure for the last name, even if I sort by FIRST or LAST. I have tried using a numeric column that is sorted by the name column and using MIN or MAX. It always shows me the measure for the last name. It looks like that TopN in the visual filter setting is not working correctly. Are my settings for TopN incorrect or is there another way to achieve that?
Date visual filter missing after upgrade
Hi We recently upgraded our Power BI Report Server from January 2019 (we also briefly had a test server for January 2022) to September 2022. The date visual filter is now gone on my graph. I used to get: Now I get (note no Date visual filter): How can I get the visual filter back?
Add a new flag in "Enlighten World Flag" visual
Hello! I'm currently working on a new project and I have a country filter. So I used the Enlighten World Flag visual object to make the country flags appear. In my list of countries, I have the Benelux (Belgium, Netherlands and Luxembourg) and I have an internal flag that I would like to show. Do you have an idea of how to proceed? Thanks a lot! Jean-RiSlicer value dynamical selection of visual
Hi All, There are 6 visuals on the page which display line chart for "no of orders" over time( month by month) a team receives. for example Team consists of 10 salesmen. To compare, the requirement is to let user select upto 6 salesmen. Based on the selection of user, for exampe if user chooses 4 sales men, we wanted to show 4 visuals. There are other ways to compare too but just wanted to stick with this idea to keep 6 visuas per page and show only no of visuals based on no of salesmen seleted. Thanks in advance If I create this scenario with example it will be like Salesman SalesmanID Saleman Name 1 David 2 Michael 3 John 4 Liza 5 Andy 6 Josh 7 Felix 8 Toby 9 Adam 10 Richard Sales SalesmanID OrderDate OrderID 1 10/12/2020 1 1 4/4/2020 2 1 1/5/2020 3 2 7/7/2020 4 3 10/12/2020 5 4 4/8/2020 6 5 1/1/2020 7 4 10/12/2020 8 3 4/4/2020 9 6 7/8/2020 10 7 1/1/2020 11 8 10/12/2020 12 9 4/4/2020 13 8 7/9/2020 14 7 4/4/2020 15 4 10/12/2020 16 4 1/1/2020 17 3 4/6/2020 18 1 7/7/2020 19 2 10/12/2020 20 5 4/4/2020 21 6 1/1/2020 22 7 10/12/2020 23 10 7/10/2020 24 10 1/1/2020 25 10 10/12/2020 26 10 1/10/2020 27 3 3/3/2020 28 6 5/5/2020 29 9 5/5/2020 30 1 10/12/2020 31 2 4/4/2020 32 3 1/10/2020 33 4 7/7/2020 34 5 10/12/2020 35 6 10/12/2020 36 7 4/4/2020 37 8 1/11/2020 38 9 7/11/2020 39 10 10/12/2020 40 1 10/12/2020 41 2 4/4/2020 42 3 1/11/2020 43 4 7/7/2020 44 5 10/12/2020 45 6 11/12/2020 46 7 4/4/2020 47 8 1/1/2020 48 9 7/7/2020 49 10 10/12/2020 50 1 10/12/2020 51 2 4/4/2020 52 3 1/1/2020 53 4 7/7/2020 54 5 10/12/2020 55 6 10/12/2020 56 7 4/4/2020 57 8 1/1/2020 58 9 6/11/2020 59 10 12/12/2020 60Measure: show dcount as % by date hierarchy
Hey everyone, i've just started in power bi and im having trouble with some calculations, for starters i just nee to calculate and graph the On Time KPI foe my company deliveries. I have scheduled delivery date and time with low and high limits as first set of data, an then i have the real delivery date and time, everything identified by a unique delivery ID. I basically need to calculate compliance % in 3 levels (Early, on time, and late) and graph them by date hierarchy. My data structure is as follows: Guide Min Time of Arrival Max Time of Arrival Arrival Time On Time On Time (groups) 12345 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 05:00 Early On Time 23456 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 06:30 On Time On Time 34567 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 14:00 Late Late On Time - Column is the result of the following calculation: (which i added in Power Query using M while transfoirming my data) = Table.AddColumn(#"Extract - Hora Creación", "On Time", each if [Tiempo Llegada] < [Tiempo Min Entrega] then "Anticipado" else if [Tiempo Llegada] > [Tiempo Max Entrega] then "Retraso" else "On Time") On Time (groups) - just groups early and on time for practical purposes my company considers both as acceptable, so if the sum of both is greater than 70% everything is ok. I tried the following dax formula for the measure im trying to graph and it does. On Time KPI = CALCULATE(COUNT(Beetrack[On Time]),ALLEXCEPT(Beetrack,Beetrack[Tiempo min entrega].[Día],Beetrack[On Time])) / CALCULATE(COUNT(Beetrack[On Time]),ALLEXCEPT(Beetrack,Beetrack[Tiempo min entrega].[Día])) The problem here is the resulting graphs cant be affected by any filter, and cant be drilled down/up by any date hierarchies, so i cant show monthly nor annual nor weekly values. I also cant highligt the same data when i click on other graphs in the dashboard to segment the data. Is there any other way to achieve the same calculation dynamically? so i can get the values by date hierarchies? and that the graph is not always static?How to show the bottom N in visual card
Hi I try to figure out how to show in Visual Card the Bottom N sales person, so i created 2 measures Count Sales Amt Visual Card result shoul be "Johnny Bi" but card show only the first sales person. I try to use the TOPN but still first sales person appear. pls. helpDaisy Chain Visuals
New to Power BI. Working with Power Apps and SharePoint. I've created a Report that has several visuals - one Table and two Clustered bar charts. I would like basically a step-down functionality pointing to specific data based on the choice in the previous chart. What I get now is the number part. In 'nuetral' I can see grand totals, across multiple areas in visual 1. If I click on one of the grand total graph lines in visual 1 it triggers a sub-set of data in visual 2. I go from Total items in the store to specifically Total items of fruit (kind of thing). What I need is when I click on a sub-set fruit graph line in visual 2 I need the data in the sheet to be specific the the type of fruit represented by the bar graph choice in visual 2 & only in the 'Area' represented by the choice made in visual 1. 1. Visual 1 shows a chart with all 50 starts and a line representing the number of cites in each state. 2. If you click on a State in visual 1 the chart in visual 2 displays a list of cities based on location (east, west, north, south), with the number on the graph line representing the number of cities in each 'Area'. 3. If you click on visual 2 graph line the Table display specific Building information, based on the Area chosen in visual 2 & the State chosed in visual 1 - ONLY.
Show SelectedYear and Future Years data in Bar Chart
Hi, My Report has date_dim and benefits_fact table which has measure benefits along with Year & Month columns I have three pages report with different views(hard coded filters of other dimensional columns). I have Year slicer from date dimension on all three pages and sync is in tact when one slicer is selected in any page all of them pages filters by selected year. In one of the pages, I have a bar chart which needs to displayed with selected year and plus 3 future years .. For example if year 2020 is selected then I need to show 2020,2021,2022,2023 and if year 2021 is selected I need to show 2021,2022,2023,2024. How can I achieve this via DAX . Please help or guide me with an approach Thanks JaydenWord Cloud falling foul of 500 values max for In filter operator
Hi all, I have a word cloud on a report which when used alongside other visuals on a report page causes an error on all other visuals (selecting a word). The error that comes up is that "the maximum number of values in an In filter operator is 500' Any thoughts on how to work aroud this? Thanks, Frank
