How do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?
Dynamic Text in Text Box or Card based on slicer selection
I am trying to change the text in a text box or card based on a slicer selection. For example, if i select a country "Afghanistan", I want the text box to read "The War in Afghanistan began in 2001". If I select "Ukraine", I want the text to read "Ukraine was attacked in early 2022", and so on. I've seen similar inquiries with "VAR, RETURN, IF" DAX solutions, but I can't seem to get them to work. The column name is "Country of origin" and table name is "Orgin/Destination" Thank you
Total revenue by month and quarter is not showing up it always shows year
I'm stuck with this can someone help me please. Timeline slicer is showing same value if I toggle between year or month or Quarter It always Shows Total Revenue of the year. I have attached the snap of the Table. Can someone help me with Data Modelling Calendar table and Financials Sample Data. I'm new to this Power Bi Thanks 🙏
dynamic conditional formatting with virtual table and switch
Hi, im having an issue building dynamic conditional formatting on my visual (color columns) The reason why i need to build that are all spaces in between columns in a chart, if more trafo numbers are selected than the spaces gets bigger To do that i added a table with ColorID and HEX rgb. I want to build virtual table with all selected Serial Numbers from slicer, adding HEX rgb by matchin the ID from virtual table and colorID and then with switch return HEX rgb. The problem i have is that it always return same hex rgb with index nr 1 IndexColorTrafo = var CurrentSelection=MAX(MeasurementsByFrequency[Serial Number]) VAR SelectedTrafoIDs = VALUES(MeasurementsByFrequency[Serial Number]) VAR NumSelectedTrafoIDs = COUNTROWS(SelectedTrafoIDs) VAR VirtualTable = ADDCOLUMNS( GENERATESERIES(1, NumSelectedTrafoIDs), "TrafoID", SELECTEDVALUE(MeasurementsByFrequency[Serial Number]), "ColorID", LOOKUPVALUE(TblCSSColor[Hex rgb],TblCSSColor[ColorID],[Value]) ) RETURN VAR Output= MAXX( VirtualTable, //VAR CurrentTrafoID = [TrafoID] //RETURN IF( NumSelectedTrafoIDs = 0, BLANK(), SWITCH( TRUE(), //[TrafoID]=CurrentSelection, CONTAINSSTRING(SelectedTrafoIDs, CurrentSelection), [ColorID], BLANK() ) ) ) Return Output anyone can help?
