98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Filter: Hide rows based on a column value in a table from the da
Filter: Hide rows based on a column value in a table from the da
Resolved · Medium Priority · Version 365
Tue 20 Jun 2023, 12:49Delegate Andres said...
Andres has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course
Filter: Hide rows based on a column value in a table from the da
Hi,
I am trying to hide rows based on cell values.
All columns are in the same visual, table.
Can you please let me know how I can hide rows when the % = N/A
I have slicers with dropdown lists connected to this.
- Project
- Year
- Month
Name Total cost Total budget %
Concrete 20 30 33
Plant 0 N/A
Materials 0 N/A
Fuel N/A
Labour 20 30 33
Tue 20 Jun 2023, 16:39Trainer Jens said...
RE: Filter: Hide rows based on a column value in a table from th
Hi Andres,
Thank you for the forum question.
If a column contains both numbers and N/A, then Power BI will treat the column as text.
If you in the data model only want the numbers not N/A, filter the column to only connect to numbers in the query editor.
If you want to both have N/A and number records in the data model but only want to display number records in the visual, you can in the Filter pane filter the visual. Use the option DOES NOT CONTAIN and then type N/A in the filter box.
I hope this makes sense. Otherwise let me know.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 27 Jun 2023: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Utilize Relationships EffectivelyEstablish clear and meaningful relationships between tables in your data model. Proper relationships enable Power BI to navigate and aggregate data accurately. Pay attention to cardinality and cross-filter direction when setting up relationships to ensure the results align with your analytical requirements. |
