Forum Discussion
Show column header for no value (no data row)
Hi Anonymous
You could see the below link，wish it is helpful for you. If your problem is still unresolved, could pls provide your pbix file ? Remember to remove the confidential information.
The blank row headings that show in a matrix when mappings fail
How to hide null columns in matrix table
How to Hide empty Columns in Matrix visual?
Best Regard
Lucien Wang
I am assuming that you are using a measure in your visual.
It is true that the calculated column will give an alternate value of 0. But when you use an aggregation of any column in a measure, there will be a filter context and it will bring zero only if there are some records for those websites that are visible in the matrix (based on the filter context).
In case a website does not have data for a particular period, it does not matter whether the calculated column using DIVIDE gives 0 or not, the measure will return blank() unless you change it because there won't be any record pertaining to the filtered websites in the table for that period.
It will be better if you post your DAX code here so that someone can take a look and figure out what is going wrong. What I have mentioned is a general idea based on the limited info you gave.
Hi I have a table with dates and a table which has two numeric fields.
From those two fields I have created calculated columns to calculate numbers if they meet certain conditions.
After which turning them into measures using SUM(calculated1) solved for filter with the dates used from the date table. So weeks for no values will show as blank.
But now when I filter for a category it will also disapear which i suspect means i have a similar issue so prob should make a reference table.