Forum Discussion
Problem with Clustered column chart - wrong output report when multiple data in Values
You're on the right track with a date table. Use a column from the date table on the chart axis.
Where you may be going wrong is with the relationships from the date table to TABLE_A and TABLE_B. You want to create a relationship with the date column to a date column on each TABLE_A and TABLE_B. It looks like you currently have a datetime column and a text column on each of those tables rather than a date column.
In summary, make sure your calendar table has a date column (convert from datetime if needed) and relate it to date (not text or datetime) columns on TABLE_A and TABLE_B.
Hi AlexisOlson,
I'm very thankful for your help.
Unfortunately I'm still facing the same issue, because the output is the same showed in the last picture I posted (both blue and light blue bars have constant values). I don't know what to do...Can you share a sample file (upload and link to a pbix saved in e.g. Google Drive/Dropbox/SharePoint/OneDrive)?
I don't think I can tell why it's going wrong without seeing it.
Hi AlexisOlson, I uploaded an example file in this thread.
I repost here if you missed it. Thanks so much:Hi guys! @AlexisOlson @v-jayw-msft
Here I replicated a simplified scenario representing the issue I'm facing.
FYI, in the real case I am connected in "Import" mode to an Oracle Database.
.pbix file ---> here
(excel static data set ---> here)
As you can see in the .pbix file, I generated a report that by a slicer should dynamically edit the Stacked column chart. Unfortunately, the view is static and there is an output only when the full date range is selected. If you move the first date even just a day forward, the output totally disappears.
To see the behaviour I'd like to achieve, just drag and drop "START_DATE" in the slicer instead of "Date" (it works...).
The reason I want to use the generic Date in the slicer, is because the next step is put the different measures in the same output (a Clustered column chart, as I explaind in the main post).
The strange fact is that for other reports very similar to the one I uploaded, the output is dynamic (the only difference is that for these other reports in the filed "Values" of the Stacked column chart view there is no Measure, just simple count operations on a column).
I hope you can help me, thanks in advantage!
F.
