single measure select multiple value shows in one graph
how to show three different values in one graph Redution buckts Ex Rate New Materials scrap values 0.7 0.17 0.45 0.7 0.27 0.35 0.7 0.17 0.45 Valueof Month Values Dec 2020 120 -> starting inventory Jan 121 feb 111 March 121 --> end inventory Graph should like below any idea . thanks in advanceHow to remove Scientific Notation
In my table data looks like Scientific Notation.please find the screen shot. i have used below measure for the graph Total Month = IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])), SUM('Master Data Base'[Value])) how to trun off scientif notation in my report . i am trying to Format i am getting Error. Looking for support.
Highlight max value of specific rows and column
Hi, DAX driven help: I'd like to highlight the max sum values of a specific row and a specific column to provide orientation in a visually driven table. This will provide an orientation cross of the max value area in the blue area. Each cell in the blue area represents the max sum value for each row or column. Near the periphery of the eye the sum values are less than max. The only way I can think of doing this is adding +100 to each max value in row 0 and column 0. Then with conditional formatting I can highlight the max+100 values with another color resulting in the orientation cross. Currently, it looks like this: Expected from conditional formatting: Close-up of visual table axis: Expected column 0 max values = +100 Expected row 0 max values = +100 Here is the Excel file for anyone to help provide a solution or guidance: https://drive.google.com/file/d/1FvdnXf8kxgQpZlBQD8jgzGXEs47JTzCN/view?usp=sharing Thanks
Calculate datediff between groups and ID
Hi, I need to calculate the DateDiff between different periods grouped by ID and per group. Data looks like this: The measure must caluclate the datediff on planned end date per Project ID and must be grouped on the Stage. So e.g. the measure must show the diff between Project ID AAA and Stage B1 10/07/2021 and Project ID AAA and Stage B1 11/07/2022 which should equal to 366 days. I have a Index Column in the Table historical dates table wich can be used to order the rows inside each project ID.
Cant connect the datasource SQL Server Database in the report server
Hello Community, I created a report in the power bi desktop version and now wanted to upload the report on the report server which all worked out(once i had saved the file as a report server). I however can't seem to connect to the SQL server database as my one and only data source and can therefore not set up an automatic refresh of the report. Just some back info the report is based on an Import mods and I first created the report on the desktop version before saving the document as power bi desktop report sever document. I think the problem might be with the fact that I didn't originally create the report in the report server version of desktop and/or that there is something wrong with my connecting string(was automatically filled in and I cant edit it). On the desktop version I can refresh the data without any problem as I am connected to the SQL database but it simply doesn't work with the report server.I've attached pictures showing my error sign to give more context. I also tried the two authentication methods possible (standard authentication and Microsoft authentication and both didn't work) I would be very grateful for any assistance the community could give me,as I need to present this tomorrow to my bosses and cant find a solution. Kind regards, Philip Sinyan
