Column specific color scaling in Matrix table
Hi Experts! I am trying to colour scale based on values. When I apply conditional formatting, it is applying on the whole of the values in the Matrix table. Looking for a solution which applies colour scaling based on column specific values. Sample data can be seen in image below for understanding. Thank you for your support in advance! Result of work done(not an expected result): Desired result:Finding daily improvement for each product
Hi Experts! I am trying to figure out how to do something but cant quite grasp it, can someone help me? I want to track the "Improvement status" every day for the each product as explained in the "Desired results". To arrive "Improvement status" , I have calculated "Selling Price/Cost", "Day's Selling/Cost", "Gain". Also took the help of "Calculated table" for "Total cost" , "Total selling price" and "Day's Selling/Cost" of all the products per day as shown in the images. Please use url for raw data(data adds every day) and calculations ( https://docs.google.com/spreadsheets/d/1IfOjW_175gu1wC82Nb7CSGsSdtiXQm3tr4NcEhqrays/edit?usp=sharing) Data: Desired Result (Improvement Status) : Thank you in advance!!
Axis is dynamic - results in a column chart
Hi everyone, I am monitoring the adoption level of an application. Overall, I have a table that captures the user name and dates when they connect to the app so I can calculate how often they use it and classify them dynamically by frequency type like "high", "medium","low" depending on the period that is selected (example: users can be classified as "High" if they used the app very frequently between date A to B but the same users could be classified as "Low" if they did not use the app much between date B to C) However, the measure I created to dynamically classify the users to finally report the number of unique users with "high", "medium", and "low" use level is useless as PowerBI does not allow to display measures as X-axis so I try to find a workaround - but still have not found it... Any suggestions? I attached an excel that illustres what I try to do as well as my PowerBI draft then. Thanks a lot! Excel illustration: https://easyupload.io/82x39b PowerBI draft: https://easyupload.io/monkm2How 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.
Compare periods of data uploads (not necesarrily dates)
Hi everybody! I am working on a report and I present the amount of money spend per period using this graph and the table underlyint this graph: This is pretty straigthforward, but i am looking for a way to only visualize the amount of money spend per period instead of the cumulative of everything. As a quick solution i made seperate measures, where i manually subtracked Gebbedrag2 - Gebbedrag1 etc. The results are shown the following table. However, it is difficult to make a nice visual with this and it will take manual work everytime i update this report. Does somebody know the right formulas to get to this point, without having to make new measures everytime i upload something? Underneath i posted a table with a simplified version of the data i use. index date created post geboekt bedrag 1 7-1-2021 material 2510841 1 7-1-2021 staff 6528437 1 7-1-2021 overhead 131079 1 7-1-2021 food 35334 2 29-1-2021 material 2543553 2 29-1-2021 staff 6528437 2 29-1-2021 overhead 131079 2 29-1-2021 food 35334 3 8-3-2021 material 2596334 3 8-3-2021 staff 6528437 3 8-3-2021 overhead 137673 3 8-3-2021 food 35334 4 7-4-2021 material 2655314 4 7-4-2021 staff 7738437 4 7-4-2021 overhead 143647 4 7-4-2021 food 35334 Thanks!
Report Matrix how to show
Hallo zusammen, ich brauche eure Hilfe zum Thema Darstellung. Ich habe in einem Tabel das Feld Funktion in diesem gibt es D=Discharte / L=Load und ich habe in einem weiteren Feld die zugehörige Trade Area sowie die entsprechenden Werte dazu. Nun möchte ich in der Matrix folgende Darstellung haben: Load / Discharge BALTIC GNS Total ARA 100 50 150 IC 70 80 150 Total 170 130 300 Wie kann man dies umsetzten, mir fehlt die Erfahrung beim Bauen eines entsprechenden Measures. Danke und Gruß LeifHow to get count based on the the filter selected.
Hi Guys, Can you please help me how i will get the count based on the filter selected. I have month data like 1,2,3,4,5 if i select all it should give me result as "5" else based on the numbers of month selected it should give. If in filter, i have selected 1,4,5 then i am expecting result as 3. Please help me how i can achieve this based on the filter selection it should get me the result. Thanks.Moving Benchmark
Hi All, please I have hit a little snag .. I have a formula that was supposed to calculate the water consumption weekly but the benchmark I want to be flexible depending on the number of persons available in that week. columns : Average headcount week number KPI's one person is assumed to consume a minimum of 1.5 liters weekly NW Benchmark = Calculate(sumx(FASENV,FASENV[headcount]*1.5),filter(FASENV,FASENV[Location] in{("Average Head Count - Staff House I"),("Average Head Count - Staff House II"),("Average Head Count - Staff House III"),("Average Head Count - Staff House IV"),("Average Head Count - Office")})) Kindly assist avanderschilden Anonymous HotChilli Nathaniel_C
