How to illustrate two groups of measures from one column in an overlay (picture encloses)
Hello, I have a requirement to show measure results depending on different temperatures (ambient temperature about 20 degree and heated temperature above 90 degree). There are several test rows showing the results depending on time and temperature. For the two temperatures areas (ambient and heated) I want to compare the results as show below, but with different colors per temperature area (ambient and heated) and not connect to eachother as show. My way to show was just limited. Sorry for that. The goal is t show that I can achieve a better result wih heated or ambient temperature. Here the data table Test-No. Temp (°C) Time/ sec Result 1 99,5 10 18 2 101 20 12 3 100,2 30 8 4 99,45 40 6 5 99,8 50 5 6 99,52 60 4 7 102 70 3,5 8 101 80 3 9 100,3 90 2,5 10 99,6 100 3 11 20 10 18 12 20,3 20 16 13 20,4 30 13 14 21 40 11 15 20,3 50 9 16 19,8 60 8 17 22 70 7 18 21 80 6 19 20,3 90 5 20 21 100 4 Thanks so much in advance. reg. Klaus
Sort group bins by dragging
It would be quite nice if you could drag and drop the groups inside of 'List' group type so that a user can have control over the order in which the groups are presented. In the example below the ideal order would be progressive from the smallest value to the largest. Plugging this into a slicer causes the values to present as:
Adjust matrix dates (in intervals) based on slicer selection
Hello, I have a Power BI report where I am using the Matrix Visual and have a date slicer. In the matrix, I have the Date value in the Column field. I need the dates to adjust with the dates selected in the slicer and also show in intervals of 7 days. I have tried binning the Date field into 7 days, but the last day shown in the Matrix is related to the latest Sunday, vs the last date selected in the slicer. I have also tried several dax formulas, but I can only get the last date shown in the matrix to correspond with the Maximum date in my data set. Any ideas on a formula that will allow me to show the Date field in the matrix in increments of 7 days and also display the last date that corresponds with the latest date selected in the slicer? (In my example below, the last date in the matrix should be 8/31 instead of 9/2). Here is the formula I am using to achieve this:
Group values together based on field value and create new combined value
Hi looking for a way to do this without creating a separate Table or a calculated Column. But looking for way to create a Measure that would combine a Sales Category for only certain Customers into a new combined value. See below, Lets lets say Customer Bill Gates has sales in multiple Sales Category and I'm looking to create a Measure that says" If Customer="Bill Gates" then combine Sales Category, else show Sales Category. So looking for 1. Ability to statically enter Certain\multiple Customers to apply this to 2. Ability to statically list certain\multiple Sales Categories that I want to combine and the other Sales category will just be listed as normal. 3. Name this new comobined value any name that I want. Anyone have any ideas on how to do this with a measure? See example below. Before results: Customer Sales Category Sales$ Bill Gates Software 1,000 Bill Gates Hardware 500 Bill Gates Internet 200 Bill Nine Science 200 Tiger Woods Golf 99999 Tiger Woods Promo 5 Expected Results: ( I would put in the Measure 2 things, Customer Name = "Bill Gates", and Sales Category to combine = "Software" and "Hardware" ) and have the new Combined Value be called "Combined" Customer Sales Category Sales$ Bill Gates Combined 1,500 Bill Gates Internet 200 Bill Nine Science 200 Tiger Woods Golf 99999 Tiger Woods Promo 5Unable to add a 'Group' under Security Role
Hi Folks, I logged in as PBI Server Admin to the web portal . We had an Active Directory Security Group in the domain. But when trying to assign the group (domin\groupname) to access a PBI Report, I am getting the following error The user or group name 'domain\groupname' is not recognized. I even tried restarting the PBI Server but no luck. Assigning the report to individual users is happening without any trouble. Any kind of information is very much appreciated
