Forum Discussion
Build Reports Similar to Q&A Visualizations
The Q&A Search feature for a dashboard allows you to build some pretty complex visualizations on record counts. I would, however, like to build these same types of charts as reports so that I can drill from the dashboard to more comprehensive data. An example of one such report is shown below.
The pie chart is displaying counts of demand header records (i.e. sales orders) for given sales channels. The information that is being summarized is coming from dimension tables in the model and not the lowest level fact table. it appears that PowerBI is adding some value level filters to filter on the relationship levels rather than using the fact table as the data.
However, I do not see a way when building a report to do this same thing. Does anyone know if this is possible?
3 Replies
- Greg_Deckler
Community Champion
Can you post a diagram of your data model (diagram view)?
The full model is quite large, but here's the portion that pertains to this visualization is an ER format. I want a count of DimDemandHeader records by the DimDemandChannels.ChannelId value.
The lowest level data is in the green FACT table, and all others are dimensions off of this.
- andre
Memorable Member
I don't not think it is possible. The only way to reliably make this work is to create a measure on the fact table that would do a COUNTROWS() type thing on the fact records and then use that measure name in your Q&A query.
