Forum Discussion
Data grouping for graphical use
Most people use this:
https://msdn.microsoft.com/en-us/query-bi/dax/dax-function-reference
For the first one it would be something like:
Measure = SWITCH( MAX([Parameters!Grouping.Value]), "Department",MAX([Fields!Department.Value]), "Division",MAX([Fields!Division.Value]), "Location",MAX([Fields!Location.Value]) )But, incredibly difficult to say without sample/example data. And I'm not even sure you want to be using DAX honestly, you might want to use M (Power Query). Just not nearly enough information to know.
Most people use this:
https://msdn.microsoft.com/en-us/query-bi/dax/dax-function-reference
For the first one it would be something like:
Measure =
SWITCH(
MAX([Parameters!Grouping.Value]),
"Department",MAX([Fields!Department.Value]),
"Division",MAX([Fields!Division.Value]),
"Location",MAX([Fields!Location.Value])
)
But, incredibly difficult to say without sample/example data. And I'm not even sure you want to be using DAX honestly, you might want to use M (Power Query). Just not nearly enough information to know.
Hi Greg
This is what I am trying to do with the data....
I have tried to Turn on responsive under "General" formatting and Turn off "Concatenate labels" under..
Or get
Image in the previous post has some sample data...I was looking at SQL Syntax and trying to replicate that in Power BI..the table name is Data_ columns are also called division location and department..
What I really need is sample data that can be copied and pasted into an Enter Data query. Doesn't have to be real data or even much of it.
Ok Greg...
Youll have it tomorrow..thanks once again