Forum Discussion
Problem with Clustered column chart - wrong output report when multiple data in Values
Hi FabioF ,
The relationships should be:
DATE_FOR_REPORT_A(date format)and Date(date format)
DATE_FOR_REPORT_B(date format)and Date(date format)
Then use Date as the x-axis of the chart.
The thing is will MEASURE_A and MEASURE_B be affected by the x_axis?
You may need to add date condition to your formula, like:
measure = calculate([value],filter(table,condition1&&condition2&&DATE_FOR_REPORT = selectedvalue(date)))
If I misunderstood your meaning, please show some sample data and expected result to us.
Best Regards,
Jay
Hi Anonymous , I renew my thanks for your support.
Here the example files if you missed it in a post above:
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.
