Forum Discussion
Create Bar Chart That Compares Counts Of Values Across Multiple Columns
Hi Everyone. I have a challenging question around creating a specific type of bar chart. Based on the data below, you can see that there are 5 Resources (column headers). The Row data are job ID...
You are welcome. No, you should not need multiple queries. All your visuals and calculations should be based on the unpivoted dataset.
Hi Ashish_Mathur,. Since my "EVENT" table which contains the Resource columns listed above, and additional columns, how do i filter down the measure to only use specific columns in the count? =DISTINCTCOUNT(Data[Job ID])
I know we can use the filter where the visuals are too, but is that the only way?
Hi,
I do not understand your question. Share some data and show the expected result.